﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="EAReject.aspx.cs" Inherits="EAReject" %>
<%@ Register TagPrefix="CustUserCtrl" TagName="Header" Src="Header.ascx" %>
<%@ Register TagPrefix="CustUserCtrl" TagName="Footer" Src="Footer.ascx" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<script language="javascript" type="text/javascript" src="WdatePicker.js"></script>
<head id="Head1" runat="server">
    <title>Street Smart Energy Admin</title>
    <link type="text/css" rel="stylesheet" href="style.css" />
</head>
<body>


    <form id="form1" runat="server">
    <div>
        <CustUserCtrl:Header ID="Header" runat="server"></CustUserCtrl:Header>
        <h1>Energy Australia Reject Form</h1>



        <asp:Button ID="Button5" runat="server" onclick="Button5_Click" 
            Text="Sales Reject Form" />
        <asp:Button ID="Button6" runat="server" onclick="Button6_Click" 
            Text="Cancellation Reject Form" />

        <asp:Button ID="Button1" runat="server" Text="ReadCancsRejects" 
            onclick="Button1_Click" />
        <asp:Button ID="Button2" runat="server" Text="ReadSalesRejects" 
            onclick="Button2_Click" />
        <asp:Button ID="Button3" runat="server" Text="WriteCancsFixed" 
            onclick="Button3_Click" />
        <asp:Button ID="Button4" runat="server" Text="WriteSalesFixed" 
            onclick="Button4_Click" />

        <asp:MultiView ID="MultiView1" runat="server" ActiveViewIndex="0"    >
            <asp:View ID="View1" runat="server">
            </asp:View>

            <asp:View ID="View2" runat="server">
            <h2>Energy Australia Sales Reject Form</h2>


        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>" 
            DeleteCommand="DELETE FROM [tblEAReject] WHERE [ID] = @original_ID" 
            InsertCommand="INSERT INTO [tblEAReject] ([CHANNEL], [LOAD_NO], [FILE_NAME], [FILE_LINE_NO], [VERBAL_ACCEPTANCE_NO], [VALIDATION_TYPE], [COMMENTS], [CANCELLATION_DATE], [CUSTOMER_TYPE], [DATE_ACCEPTED], [DOCUMENT_NUMBER], [SITE_STATE], [AGEING_FROM_INITIAL_LOAD]) VALUES (@CHANNEL, @LOAD_NO, @FILE_NAME, @FILE_LINE_NO, @VERBAL_ACCEPTANCE_NO, @VALIDATION_TYPE, @COMMENTS, @CANCELLATION_DATE, @CUSTOMER_TYPE, @DATE_ACCEPTED, @DOCUMENT_NUMBER, @SITE_STATE, @AGEING_FROM_INITIAL_LOAD)" 
            OldValuesParameterFormatString="original_{0}" 
            SelectCommand="SELECT * FROM [tblEAReject]" 
            
                    
                    
                    UpdateCommand="UPDATE [tblEAReject] SET [CHANNEL] = @CHANNEL, [LOAD_NO] = @LOAD_NO, [FILE_NAME] = @FILE_NAME, [FILE_LINE_NO] = @FILE_LINE_NO, [VERBAL_ACCEPTANCE_NO] = @VERBAL_ACCEPTANCE_NO, [VALIDATION_TYPE] = @VALIDATION_TYPE, [COMMENTS] = @COMMENTS, [CANCELLATION_DATE] = @CANCELLATION_DATE, [CUSTOMER_TYPE] = @CUSTOMER_TYPE, [DATE_ACCEPTED] = @DATE_ACCEPTED, [DOCUMENT_NUMBER] = @DOCUMENT_NUMBER, [SITE_STATE] = @SITE_STATE, [AGEING_FROM_INITIAL_LOAD] = @AGEING_FROM_INITIAL_LOAD WHERE [ID] = @original_ID">
            <DeleteParameters>
                <asp:Parameter Name="original_ID" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="CHANNEL" Type="String" />
                <asp:Parameter Name="LOAD_NO" Type="String" />
                <asp:Parameter Name="FILE_NAME" Type="String" />
                <asp:Parameter Name="FILE_LINE_NO" Type="Decimal" />
                <asp:Parameter Name="VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter Name="VALIDATION_TYPE" Type="String" />
                <asp:Parameter Name="COMMENTS" Type="String" />
                <asp:Parameter Name="CANCELLATION_DATE" Type="DateTime" />
                <asp:Parameter Name="CUSTOMER_TYPE" Type="String" />
                <asp:Parameter Name="DATE_ACCEPTED" Type="String" />
                <asp:Parameter Name="DOCUMENT_NUMBER" Type="String" />
                <asp:Parameter Name="SITE_STATE" Type="String" />
                <asp:Parameter Name="AGEING_FROM_INITIAL_LOAD" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="CHANNEL" Type="String" />
                <asp:Parameter Name="LOAD_NO" Type="String" />
                <asp:Parameter Name="FILE_NAME" Type="String" />
                <asp:Parameter Name="FILE_LINE_NO" Type="Decimal" />
                <asp:Parameter Name="VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter Name="VALIDATION_TYPE" Type="String" />
                <asp:Parameter Name="COMMENTS" Type="String" />
                <asp:Parameter Name="CANCELLATION_DATE" Type="DateTime" />
                <asp:Parameter Name="CUSTOMER_TYPE" Type="String" />
                <asp:Parameter Name="DATE_ACCEPTED" Type="String" />
                <asp:Parameter Name="DOCUMENT_NUMBER" Type="String" />
                <asp:Parameter Name="SITE_STATE" Type="String" />
                <asp:Parameter Name="AGEING_FROM_INITIAL_LOAD" Type="String" />
                <asp:Parameter Name="original_ID" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" CssClass="mGrid"
            PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" 
            AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="ID" 
            DataSourceID="SqlDataSource1" EnableModelValidation="True">
            <AlternatingRowStyle CssClass="alt"></AlternatingRowStyle>
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" 
                    ShowSelectButton="True" />
                <asp:BoundField DataField="ID" HeaderText="ID" 
                    SortExpression="ID" InsertVisible="False" ReadOnly="True" />
                <asp:BoundField DataField="CHANNEL" HeaderText="CHANNEL" 
                    SortExpression="CHANNEL" />
                <asp:BoundField DataField="LOAD_NO" HeaderText="LOAD_NO" 
                    SortExpression="LOAD_NO" />
                <asp:BoundField DataField="FILE_NAME" HeaderText="FILE_NAME" 
                    SortExpression="FILE_NAME" />
                <asp:BoundField DataField="FILE_LINE_NO" 
                    HeaderText="FILE_LINE_NO" SortExpression="FILE_LINE_NO" />
                <asp:BoundField DataField="VERBAL_ACCEPTANCE_NO" HeaderText="VERBAL_ACCEPTANCE_NO" 
                    SortExpression="VERBAL_ACCEPTANCE_NO" />
                <asp:BoundField DataField="VALIDATION_TYPE" HeaderText="VALIDATION_TYPE" 
                    SortExpression="VALIDATION_TYPE" />
                <asp:BoundField DataField="COMMENTS" HeaderText="COMMENTS" 
                    SortExpression="COMMENTS" />
                <asp:BoundField DataField="CANCELLATION_DATE" HeaderText="CANCELLATION_DATE" 
                    SortExpression="CANCELLATION_DATE" />
                <asp:BoundField DataField="CUSTOMER_TYPE" HeaderText="CUSTOMER_TYPE" 
                    SortExpression="CUSTOMER_TYPE" />
                <asp:BoundField DataField="DATE_ACCEPTED" HeaderText="DATE_ACCEPTED" 
                    SortExpression="DATE_ACCEPTED" />
                <asp:BoundField DataField="DOCUMENT_NUMBER" 
                    HeaderText="DOCUMENT_NUMBER" 
                    SortExpression="DOCUMENT_NUMBER" />
                <asp:BoundField DataField="SITE_STATE" 
                    HeaderText="SITE_STATE" 
                    SortExpression="SITE_STATE" />
                <asp:BoundField DataField="AGEING_FROM_INITIAL_LOAD" 
                    HeaderText="AGEING_FROM_INITIAL_LOAD" 
                    SortExpression="AGEING_FROM_INITIAL_LOAD" />
            </Columns>
            <PagerStyle CssClass="pgr" />
        </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource5" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>" 
                    
                    SelectCommand="SELECT [ID], [VERBAL_ACCEPTANCE_NO], [CANCELLATION_DATE], [CUSTOMER_TYPE], [DATE_ACCEPTED], [VALIDATION_TYPE] FROM [tblEAReject] WHERE ([ID] = @ID)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="GridView1" Name="ID" 
                            PropertyName="SelectedValue" Type="Int32" />
                    </SelectParameters>
                </asp:SqlDataSource>
        <asp:GridView ID="GridView3" runat="server" CssClass="mGrid"
            PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" 
                    AutoGenerateColumns="False" DataKeyNames="VERBAL_ACCEPTANCE_NO" 
            DataSourceID="SqlDataSource5" EnableModelValidation="True">
            <AlternatingRowStyle CssClass="alt"></AlternatingRowStyle>
            <Columns>
                        <asp:TemplateField ShowHeader="False">
                            <ItemTemplate>
                                <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" 
                                    CommandName="Select" Text="Edit EA Form Detail"></asp:LinkButton>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" 
                            ReadOnly="True" SortExpression="ID" />
                        <asp:BoundField DataField="VERBAL_ACCEPTANCE_NO" HeaderText="VERBAL_ACCEPTANCE_NO" 
                            SortExpression="VERBAL_ACCEPTANCE_NO" />
                        <asp:BoundField DataField="CANCELLATION_DATE" HeaderText="CANCELLATION_DATE" 
                            SortExpression="CANCELLATION_DATE" />
                        <asp:BoundField DataField="CUSTOMER_TYPE" HeaderText="CUSTOMER_TYPE" 
                            SortExpression="CUSTOMER_TYPE" />
                        <asp:BoundField DataField="DATE_ACCEPTED" HeaderText="DATE_ACCEPTED" 
                            SortExpression="DATE_ACCEPTED" />
                        <asp:BoundField DataField="VALIDATION_TYPE" 
                            HeaderText="VALIDATION_TYPE" SortExpression="VALIDATION_TYPE" />
                    </Columns>
                <PagerStyle CssClass="pgr" />
                </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConflictDetection="CompareAllValues" 
            ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>" 
            DeleteCommand="DELETE FROM [tblEA] WHERE [ID] = @original_ID AND (([UserID] = @original_UserID) OR ([UserID] IS NULL AND @original_UserID IS NULL)) AND (([CAMPAINGN_NUMBER] = @original_CAMPAINGN_NUMBER) OR ([CAMPAINGN_NUMBER] IS NULL AND @original_CAMPAINGN_NUMBER IS NULL)) AND (([VERBAL_ACCEPTANCE_NO] = @original_VERBAL_ACCEPTANCE_NO) OR ([VERBAL_ACCEPTANCE_NO] IS NULL AND @original_VERBAL_ACCEPTANCE_NO IS NULL)) AND (([DATE_ACCEPTED] = @original_DATE_ACCEPTED) OR ([DATE_ACCEPTED] IS NULL AND @original_DATE_ACCEPTED IS NULL)) AND (([CALL_TYPE] = @original_CALL_TYPE) OR ([CALL_TYPE] IS NULL AND @original_CALL_TYPE IS NULL)) AND (([FUEL_TYPE] = @original_FUEL_TYPE) OR ([FUEL_TYPE] IS NULL AND @original_FUEL_TYPE IS NULL)) AND (([CUSTOMER_TYPE] = @original_CUSTOMER_TYPE) OR ([CUSTOMER_TYPE] IS NULL AND @original_CUSTOMER_TYPE IS NULL)) AND (([NETWORK_AREA] = @original_NETWORK_AREA) OR ([NETWORK_AREA] IS NULL AND @original_NETWORK_AREA IS NULL)) AND (([OFFER_SELECTION] = @original_OFFER_SELECTION) OR ([OFFER_SELECTION] IS NULL AND @original_OFFER_SELECTION IS NULL)) AND (([PRODUCT_INCENTIVE] = @original_PRODUCT_INCENTIVE) OR ([PRODUCT_INCENTIVE] IS NULL AND @original_PRODUCT_INCENTIVE IS NULL)) AND (([UPFRONT_DISCOUNT] = @original_UPFRONT_DISCOUNT) OR ([UPFRONT_DISCOUNT] IS NULL AND @original_UPFRONT_DISCOUNT IS NULL)) AND (([OFFER_PARTNER] = @original_OFFER_PARTNER) OR ([OFFER_PARTNER] IS NULL AND @original_OFFER_PARTNER IS NULL)) AND (([COMPANY_NAME] = @original_COMPANY_NAME) OR ([COMPANY_NAME] IS NULL AND @original_COMPANY_NAME IS NULL)) AND (([TRADING_NAME] = @original_TRADING_NAME) OR ([TRADING_NAME] IS NULL AND @original_TRADING_NAME IS NULL)) AND (([COMPANY_POSITION] = @original_COMPANY_POSITION) OR ([COMPANY_POSITION] IS NULL AND @original_COMPANY_POSITION IS NULL)) AND (([ABN] = @original_ABN) OR ([ABN] IS NULL AND @original_ABN IS NULL)) AND (([TITLE] = @original_TITLE) OR ([TITLE] IS NULL AND @original_TITLE IS NULL)) AND (([FIRST_NAME] = @original_FIRST_NAME) OR ([FIRST_NAME] IS NULL AND @original_FIRST_NAME IS NULL)) AND (([LAST_NAME] = @original_LAST_NAME) OR ([LAST_NAME] IS NULL AND @original_LAST_NAME IS NULL)) AND (([BILL_NAME_1] = @original_BILL_NAME_1) OR ([BILL_NAME_1] IS NULL AND @original_BILL_NAME_1 IS NULL)) AND (([BILL_NAME_2] = @original_BILL_NAME_2) OR ([BILL_NAME_2] IS NULL AND @original_BILL_NAME_2 IS NULL)) AND (([DOB] = @original_DOB) OR ([DOB] IS NULL AND @original_DOB IS NULL)) AND (([DRIVERS_LICENCE] = @original_DRIVERS_LICENCE) OR ([DRIVERS_LICENCE] IS NULL AND @original_DRIVERS_LICENCE IS NULL)) AND (([HPHONE] = @original_HPHONE) OR ([HPHONE] IS NULL AND @original_HPHONE IS NULL)) AND (([BPHONE] = @original_BPHONE) OR ([BPHONE] IS NULL AND @original_BPHONE IS NULL)) AND (([MOBILE] = @original_MOBILE) OR ([MOBILE] IS NULL AND @original_MOBILE IS NULL)) AND (([EMAIL] = @original_EMAIL) OR ([EMAIL] IS NULL AND @original_EMAIL IS NULL)) AND (([TITLE_CUST_2] = @original_TITLE_CUST_2) OR ([TITLE_CUST_2] IS NULL AND @original_TITLE_CUST_2 IS NULL)) AND (([FIRST_NAME_CUST_2] = @original_FIRST_NAME_CUST_2) OR ([FIRST_NAME_CUST_2] IS NULL AND @original_FIRST_NAME_CUST_2 IS NULL)) AND (([LAST_NAME_CUST_2] = @original_LAST_NAME_CUST_2) OR ([LAST_NAME_CUST_2] IS NULL AND @original_LAST_NAME_CUST_2 IS NULL)) AND (([DOB_CUST_2] = @original_DOB_CUST_2) OR ([DOB_CUST_2] IS NULL AND @original_DOB_CUST_2 IS NULL)) AND (([DRIVERS_LICENCE_CUST_2] = @original_DRIVERS_LICENCE_CUST_2) OR ([DRIVERS_LICENCE_CUST_2] IS NULL AND @original_DRIVERS_LICENCE_CUST_2 IS NULL)) AND (([HPHONE_CUST_2] = @original_HPHONE_CUST_2) OR ([HPHONE_CUST_2] IS NULL AND @original_HPHONE_CUST_2 IS NULL)) AND (([BPHONE_CUST_2] = @original_BPHONE_CUST_2) OR ([BPHONE_CUST_2] IS NULL AND @original_BPHONE_CUST_2 IS NULL)) AND (([MOBILE_CUST_2] = @original_MOBILE_CUST_2) OR ([MOBILE_CUST_2] IS NULL AND @original_MOBILE_CUST_2 IS NULL)) AND (([EMAIL_CUST_2] = @original_EMAIL_CUST_2) OR ([EMAIL_CUST_2] IS NULL AND @original_EMAIL_CUST_2 IS NULL)) AND (([RELATIONSHIP_CODE] = @original_RELATIONSHIP_CODE) OR ([RELATIONSHIP_CODE] IS NULL AND @original_RELATIONSHIP_CODE IS NULL)) AND (([DO_NOT_CONTACT] = @original_DO_NOT_CONTACT) OR ([DO_NOT_CONTACT] IS NULL AND @original_DO_NOT_CONTACT IS NULL)) AND (([SITE_ADD1] = @original_SITE_ADD1) OR ([SITE_ADD1] IS NULL AND @original_SITE_ADD1 IS NULL)) AND (([SITE_SUBURB] = @original_SITE_SUBURB) OR ([SITE_SUBURB] IS NULL AND @original_SITE_SUBURB IS NULL)) AND (([SITE_STATE] = @original_SITE_STATE) OR ([SITE_STATE] IS NULL AND @original_SITE_STATE IS NULL)) AND (([SITE_POSTCODE] = @original_SITE_POSTCODE) OR ([SITE_POSTCODE] IS NULL AND @original_SITE_POSTCODE IS NULL)) AND (([POST_ADDRESS_1] = @original_POST_ADDRESS_1) OR ([POST_ADDRESS_1] IS NULL AND @original_POST_ADDRESS_1 IS NULL)) AND (([POST_ADDRESS_2] = @original_POST_ADDRESS_2) OR ([POST_ADDRESS_2] IS NULL AND @original_POST_ADDRESS_2 IS NULL)) AND (([POST_ADDRESS_3] = @original_POST_ADDRESS_3) OR ([POST_ADDRESS_3] IS NULL AND @original_POST_ADDRESS_3 IS NULL)) AND (([POST_ADDRESS_4] = @original_POST_ADDRESS_4) OR ([POST_ADDRESS_4] IS NULL AND @original_POST_ADDRESS_4 IS NULL)) AND (([POST_SUBURB] = @original_POST_SUBURB) OR ([POST_SUBURB] IS NULL AND @original_POST_SUBURB IS NULL)) AND (([POST_STATE] = @original_POST_STATE) OR ([POST_STATE] IS NULL AND @original_POST_STATE IS NULL)) AND (([POST_POSTCODE] = @original_POST_POSTCODE) OR ([POST_POSTCODE] IS NULL AND @original_POST_POSTCODE IS NULL)) AND (([ACCOUNT_ID] = @original_ACCOUNT_ID) OR ([ACCOUNT_ID] IS NULL AND @original_ACCOUNT_ID IS NULL)) AND (([NMI] = @original_NMI) OR ([NMI] IS NULL AND @original_NMI IS NULL)) AND (([DPI] = @original_DPI) OR ([DPI] IS NULL AND @original_DPI IS NULL)) AND (([CURRENT_ELECTRICITY_RETAILER] = @original_CURRENT_ELECTRICITY_RETAILER) OR ([CURRENT_ELECTRICITY_RETAILER] IS NULL AND @original_CURRENT_ELECTRICITY_RETAILER IS NULL)) AND (([OPERATOR_NAME] = @original_OPERATOR_NAME) OR ([OPERATOR_NAME] IS NULL AND @original_OPERATOR_NAME IS NULL)) AND (([ANNUAL_CONSUMPTION] = @original_ANNUAL_CONSUMPTION) OR ([ANNUAL_CONSUMPTION] IS NULL AND @original_ANNUAL_CONSUMPTION IS NULL)) AND (([OFFER_STATUS] = @original_OFFER_STATUS) OR ([OFFER_STATUS] IS NULL AND @original_OFFER_STATUS IS NULL)) AND (([AFFILIATION_INITIAL] = @original_AFFILIATION_INITIAL) OR ([AFFILIATION_INITIAL] IS NULL AND @original_AFFILIATION_INITIAL IS NULL)) AND (([AFFILIATION_SURNAME] = @original_AFFILIATION_SURNAME) OR ([AFFILIATION_SURNAME] IS NULL AND @original_AFFILIATION_SURNAME IS NULL)) AND (([AFFILIATION_MEMBER_NO] = @original_AFFILIATION_MEMBER_NO) OR ([AFFILIATION_MEMBER_NO] IS NULL AND @original_AFFILIATION_MEMBER_NO IS NULL)) AND (([PAYMENT_OPTION] = @original_PAYMENT_OPTION) OR ([PAYMENT_OPTION] IS NULL AND @original_PAYMENT_OPTION IS NULL)) AND (([SMARTER_PAY_CREDIT] = @original_SMARTER_PAY_CREDIT) OR ([SMARTER_PAY_CREDIT] IS NULL AND @original_SMARTER_PAY_CREDIT IS NULL)) AND (([RPO_FIRST_PAYMENT_DATE] = @original_RPO_FIRST_PAYMENT_DATE) OR ([RPO_FIRST_PAYMENT_DATE] IS NULL AND @original_RPO_FIRST_PAYMENT_DATE IS NULL)) AND (([RPO_ELEC_MONTH] = @original_RPO_ELEC_MONTH) OR ([RPO_ELEC_MONTH] IS NULL AND @original_RPO_ELEC_MONTH IS NULL)) AND (([RPO_ELEC_FORTN] = @original_RPO_ELEC_FORTN) OR ([RPO_ELEC_FORTN] IS NULL AND @original_RPO_ELEC_FORTN IS NULL)) AND (([RPO_GAS_MONTH] = @original_RPO_GAS_MONTH) OR ([RPO_GAS_MONTH] IS NULL AND @original_RPO_GAS_MONTH IS NULL)) AND (([RPO_GAS_FORTN] = @original_RPO_GAS_FORTN) OR ([RPO_GAS_FORTN] IS NULL AND @original_RPO_GAS_FORTN IS NULL)) AND (([RPO_COMB_MONTH] = @original_RPO_COMB_MONTH) OR ([RPO_COMB_MONTH] IS NULL AND @original_RPO_COMB_MONTH IS NULL)) AND (([RPO_COMB_FORTN] = @original_RPO_COMB_FORTN) OR ([RPO_COMB_FORTN] IS NULL AND @original_RPO_COMB_FORTN IS NULL)) AND (([RPO_FREQ_SELECTION] = @original_RPO_FREQ_SELECTION) OR ([RPO_FREQ_SELECTION] IS NULL AND @original_RPO_FREQ_SELECTION IS NULL)) AND (([DD_DETAILS_GIVEN] = @original_DD_DETAILS_GIVEN) OR ([DD_DETAILS_GIVEN] IS NULL AND @original_DD_DETAILS_GIVEN IS NULL)) AND (([PAY_SELECTION] = @original_PAY_SELECTION) OR ([PAY_SELECTION] IS NULL AND @original_PAY_SELECTION IS NULL)) AND (([NAME_FIN_INST] = @original_NAME_FIN_INST) OR ([NAME_FIN_INST] IS NULL AND @original_NAME_FIN_INST IS NULL)) AND (([ACC_HOLDER_NAME] = @original_ACC_HOLDER_NAME) OR ([ACC_HOLDER_NAME] IS NULL AND @original_ACC_HOLDER_NAME IS NULL)) AND (([BSB] = @original_BSB) OR ([BSB] IS NULL AND @original_BSB IS NULL)) AND (([ACCOUNT_NUMBER] = @original_ACCOUNT_NUMBER) OR ([ACCOUNT_NUMBER] IS NULL AND @original_ACCOUNT_NUMBER IS NULL)) AND (([CARD_TYPE] = @original_CARD_TYPE) OR ([CARD_TYPE] IS NULL AND @original_CARD_TYPE IS NULL)) AND (([CARD_NUMBER] = @original_CARD_NUMBER) OR ([CARD_NUMBER] IS NULL AND @original_CARD_NUMBER IS NULL)) AND (([VERIF_NUMBER] = @original_VERIF_NUMBER) OR ([VERIF_NUMBER] IS NULL AND @original_VERIF_NUMBER IS NULL)) AND (([CARD_NAME] = @original_CARD_NAME) OR ([CARD_NAME] IS NULL AND @original_CARD_NAME IS NULL)) AND (([EXPIRY_DATE] = @original_EXPIRY_DATE) OR ([EXPIRY_DATE] IS NULL AND @original_EXPIRY_DATE IS NULL)) AND (([PAYMENT_OPTION_PRIOR_TO_SALE] = @original_PAYMENT_OPTION_PRIOR_TO_SALE) OR ([PAYMENT_OPTION_PRIOR_TO_SALE] IS NULL AND @original_PAYMENT_OPTION_PRIOR_TO_SALE IS NULL)) AND (([SELL_CODE] = @original_SELL_CODE) OR ([SELL_CODE] IS NULL AND @original_SELL_CODE IS NULL)) AND (([VERIFICATION_OPERATOR_COMMENTS] = @original_VERIFICATION_OPERATOR_COMMENTS) OR ([VERIFICATION_OPERATOR_COMMENTS] IS NULL AND @original_VERIFICATION_OPERATOR_COMMENTS IS NULL)) AND (([DOCUMENT_NUMBER] = @original_DOCUMENT_NUMBER) OR ([DOCUMENT_NUMBER] IS NULL AND @original_DOCUMENT_NUMBER IS NULL)) AND (([D2D_REP_NAME_ID] = @original_D2D_REP_NAME_ID) OR ([D2D_REP_NAME_ID] IS NULL AND @original_D2D_REP_NAME_ID IS NULL)) AND (([D2D_AGENCY] = @original_D2D_AGENCY) OR ([D2D_AGENCY] IS NULL AND @original_D2D_AGENCY IS NULL)) AND (([DISCOUNT_PERCENT] = @original_DISCOUNT_PERCENT) OR ([DISCOUNT_PERCENT] IS NULL AND @original_DISCOUNT_PERCENT IS NULL)) AND (([MKT_GREEN_RATIO] = @original_MKT_GREEN_RATIO) OR ([MKT_GREEN_RATIO] IS NULL AND @original_MKT_GREEN_RATIO IS NULL)) AND (([DPID] = @original_DPID) OR ([DPID] IS NULL AND @original_DPID IS NULL)) AND (([LIFE_SUPPORT] = @original_LIFE_SUPPORT) OR ([LIFE_SUPPORT] IS NULL AND @original_LIFE_SUPPORT IS NULL))" 
            InsertCommand="INSERT INTO [tblEA] ([UserID], [CAMPAINGN_NUMBER], [VERBAL_ACCEPTANCE_NO], [DATE_ACCEPTED], [CALL_TYPE], [FUEL_TYPE], [CUSTOMER_TYPE], [NETWORK_AREA], [OFFER_SELECTION], [PRODUCT_INCENTIVE], [UPFRONT_DISCOUNT], [OFFER_PARTNER], [COMPANY_NAME], [TRADING_NAME], [COMPANY_POSITION], [ABN], [TITLE], [FIRST_NAME], [LAST_NAME], [BILL_NAME_1], [BILL_NAME_2], [DOB], [DRIVERS_LICENCE], [HPHONE], [BPHONE], [MOBILE], [EMAIL], [TITLE_CUST_2], [FIRST_NAME_CUST_2], [LAST_NAME_CUST_2], [DOB_CUST_2], [DRIVERS_LICENCE_CUST_2], [HPHONE_CUST_2], [BPHONE_CUST_2], [MOBILE_CUST_2], [EMAIL_CUST_2], [RELATIONSHIP_CODE], [DO_NOT_CONTACT], [SITE_ADD1], [SITE_SUBURB], [SITE_STATE], [SITE_POSTCODE], [POST_ADDRESS_1], [POST_ADDRESS_2], [POST_ADDRESS_3], [POST_ADDRESS_4], [POST_SUBURB], [POST_STATE], [POST_POSTCODE], [ACCOUNT_ID], [NMI], [DPI], [CURRENT_ELECTRICITY_RETAILER], [OPERATOR_NAME], [ANNUAL_CONSUMPTION], [OFFER_STATUS], [AFFILIATION_INITIAL], [AFFILIATION_SURNAME], [AFFILIATION_MEMBER_NO], [PAYMENT_OPTION], [SMARTER_PAY_CREDIT], [RPO_FIRST_PAYMENT_DATE], [RPO_ELEC_MONTH], [RPO_ELEC_FORTN], [RPO_GAS_MONTH], [RPO_GAS_FORTN], [RPO_COMB_MONTH], [RPO_COMB_FORTN], [RPO_FREQ_SELECTION], [DD_DETAILS_GIVEN], [PAY_SELECTION], [NAME_FIN_INST], [ACC_HOLDER_NAME], [BSB], [ACCOUNT_NUMBER], [CARD_TYPE], [CARD_NUMBER], [VERIF_NUMBER], [CARD_NAME], [EXPIRY_DATE], [PAYMENT_OPTION_PRIOR_TO_SALE], [SELL_CODE], [VERIFICATION_OPERATOR_COMMENTS], [DOCUMENT_NUMBER], [D2D_REP_NAME_ID], [D2D_AGENCY], [DISCOUNT_PERCENT], [MKT_GREEN_RATIO], [DPID], [LIFE_SUPPORT]) VALUES (@UserID, @CAMPAINGN_NUMBER, @VERBAL_ACCEPTANCE_NO, @DATE_ACCEPTED, @CALL_TYPE, @FUEL_TYPE, @CUSTOMER_TYPE, @NETWORK_AREA, @OFFER_SELECTION, @PRODUCT_INCENTIVE, @UPFRONT_DISCOUNT, @OFFER_PARTNER, @COMPANY_NAME, @TRADING_NAME, @COMPANY_POSITION, @ABN, @TITLE, @FIRST_NAME, @LAST_NAME, @BILL_NAME_1, @BILL_NAME_2, @DOB, @DRIVERS_LICENCE, @HPHONE, @BPHONE, @MOBILE, @EMAIL, @TITLE_CUST_2, @FIRST_NAME_CUST_2, @LAST_NAME_CUST_2, @DOB_CUST_2, @DRIVERS_LICENCE_CUST_2, @HPHONE_CUST_2, @BPHONE_CUST_2, @MOBILE_CUST_2, @EMAIL_CUST_2, @RELATIONSHIP_CODE, @DO_NOT_CONTACT, @SITE_ADD1, @SITE_SUBURB, @SITE_STATE, @SITE_POSTCODE, @POST_ADDRESS_1, @POST_ADDRESS_2, @POST_ADDRESS_3, @POST_ADDRESS_4, @POST_SUBURB, @POST_STATE, @POST_POSTCODE, @ACCOUNT_ID, @NMI, @DPI, @CURRENT_ELECTRICITY_RETAILER, @OPERATOR_NAME, @ANNUAL_CONSUMPTION, @OFFER_STATUS, @AFFILIATION_INITIAL, @AFFILIATION_SURNAME, @AFFILIATION_MEMBER_NO, @PAYMENT_OPTION, @SMARTER_PAY_CREDIT, @RPO_FIRST_PAYMENT_DATE, @RPO_ELEC_MONTH, @RPO_ELEC_FORTN, @RPO_GAS_MONTH, @RPO_GAS_FORTN, @RPO_COMB_MONTH, @RPO_COMB_FORTN, @RPO_FREQ_SELECTION, @DD_DETAILS_GIVEN, @PAY_SELECTION, @NAME_FIN_INST, @ACC_HOLDER_NAME, @BSB, @ACCOUNT_NUMBER, @CARD_TYPE, @CARD_NUMBER, @VERIF_NUMBER, @CARD_NAME, @EXPIRY_DATE, @PAYMENT_OPTION_PRIOR_TO_SALE, @SELL_CODE, @VERIFICATION_OPERATOR_COMMENTS, @DOCUMENT_NUMBER, @D2D_REP_NAME_ID, @D2D_AGENCY, @DISCOUNT_PERCENT, @MKT_GREEN_RATIO, @DPID, @LIFE_SUPPORT)" 
            OldValuesParameterFormatString="original_{0}" 
            SelectCommand="SELECT * FROM [tblEA] WHERE ([VERBAL_ACCEPTANCE_NO] = @VERBAL_ACCEPTANCE_NO)" 
            UpdateCommand="UPDATE [tblEA] SET [UserID] = @UserID, [CAMPAINGN_NUMBER] = @CAMPAINGN_NUMBER, [VERBAL_ACCEPTANCE_NO] = @VERBAL_ACCEPTANCE_NO, [DATE_ACCEPTED] = @DATE_ACCEPTED, [CALL_TYPE] = @CALL_TYPE, [FUEL_TYPE] = @FUEL_TYPE, [CUSTOMER_TYPE] = @CUSTOMER_TYPE, [NETWORK_AREA] = @NETWORK_AREA, [OFFER_SELECTION] = @OFFER_SELECTION, [PRODUCT_INCENTIVE] = @PRODUCT_INCENTIVE, [UPFRONT_DISCOUNT] = @UPFRONT_DISCOUNT, [OFFER_PARTNER] = @OFFER_PARTNER, [COMPANY_NAME] = @COMPANY_NAME, [TRADING_NAME] = @TRADING_NAME, [COMPANY_POSITION] = @COMPANY_POSITION, [ABN] = @ABN, [TITLE] = @TITLE, [FIRST_NAME] = @FIRST_NAME, [LAST_NAME] = @LAST_NAME, [BILL_NAME_1] = @BILL_NAME_1, [BILL_NAME_2] = @BILL_NAME_2, [DOB] = @DOB, [DRIVERS_LICENCE] = @DRIVERS_LICENCE, [HPHONE] = @HPHONE, [BPHONE] = @BPHONE, [MOBILE] = @MOBILE, [EMAIL] = @EMAIL, [TITLE_CUST_2] = @TITLE_CUST_2, [FIRST_NAME_CUST_2] = @FIRST_NAME_CUST_2, [LAST_NAME_CUST_2] = @LAST_NAME_CUST_2, [DOB_CUST_2] = @DOB_CUST_2, [DRIVERS_LICENCE_CUST_2] = @DRIVERS_LICENCE_CUST_2, [HPHONE_CUST_2] = @HPHONE_CUST_2, [BPHONE_CUST_2] = @BPHONE_CUST_2, [MOBILE_CUST_2] = @MOBILE_CUST_2, [EMAIL_CUST_2] = @EMAIL_CUST_2, [RELATIONSHIP_CODE] = @RELATIONSHIP_CODE, [DO_NOT_CONTACT] = @DO_NOT_CONTACT, [SITE_ADD1] = @SITE_ADD1, [SITE_SUBURB] = @SITE_SUBURB, [SITE_STATE] = @SITE_STATE, [SITE_POSTCODE] = @SITE_POSTCODE, [POST_ADDRESS_1] = @POST_ADDRESS_1, [POST_ADDRESS_2] = @POST_ADDRESS_2, [POST_ADDRESS_3] = @POST_ADDRESS_3, [POST_ADDRESS_4] = @POST_ADDRESS_4, [POST_SUBURB] = @POST_SUBURB, [POST_STATE] = @POST_STATE, [POST_POSTCODE] = @POST_POSTCODE, [ACCOUNT_ID] = @ACCOUNT_ID, [NMI] = @NMI, [DPI] = @DPI, [CURRENT_ELECTRICITY_RETAILER] = @CURRENT_ELECTRICITY_RETAILER, [OPERATOR_NAME] = @OPERATOR_NAME, [ANNUAL_CONSUMPTION] = @ANNUAL_CONSUMPTION, [OFFER_STATUS] = @OFFER_STATUS, [AFFILIATION_INITIAL] = @AFFILIATION_INITIAL, [AFFILIATION_SURNAME] = @AFFILIATION_SURNAME, [AFFILIATION_MEMBER_NO] = @AFFILIATION_MEMBER_NO, [PAYMENT_OPTION] = @PAYMENT_OPTION, [SMARTER_PAY_CREDIT] = @SMARTER_PAY_CREDIT, [RPO_FIRST_PAYMENT_DATE] = @RPO_FIRST_PAYMENT_DATE, [RPO_ELEC_MONTH] = @RPO_ELEC_MONTH, [RPO_ELEC_FORTN] = @RPO_ELEC_FORTN, [RPO_GAS_MONTH] = @RPO_GAS_MONTH, [RPO_GAS_FORTN] = @RPO_GAS_FORTN, [RPO_COMB_MONTH] = @RPO_COMB_MONTH, [RPO_COMB_FORTN] = @RPO_COMB_FORTN, [RPO_FREQ_SELECTION] = @RPO_FREQ_SELECTION, [DD_DETAILS_GIVEN] = @DD_DETAILS_GIVEN, [PAY_SELECTION] = @PAY_SELECTION, [NAME_FIN_INST] = @NAME_FIN_INST, [ACC_HOLDER_NAME] = @ACC_HOLDER_NAME, [BSB] = @BSB, [ACCOUNT_NUMBER] = @ACCOUNT_NUMBER, [CARD_TYPE] = @CARD_TYPE, [CARD_NUMBER] = @CARD_NUMBER, [VERIF_NUMBER] = @VERIF_NUMBER, [CARD_NAME] = @CARD_NAME, [EXPIRY_DATE] = @EXPIRY_DATE, [PAYMENT_OPTION_PRIOR_TO_SALE] = @PAYMENT_OPTION_PRIOR_TO_SALE, [SELL_CODE] = @SELL_CODE, [VERIFICATION_OPERATOR_COMMENTS] = @VERIFICATION_OPERATOR_COMMENTS, [DOCUMENT_NUMBER] = @DOCUMENT_NUMBER, [D2D_REP_NAME_ID] = @D2D_REP_NAME_ID, [D2D_AGENCY] = @D2D_AGENCY, [DISCOUNT_PERCENT] = @DISCOUNT_PERCENT, [MKT_GREEN_RATIO] = @MKT_GREEN_RATIO, [DPID] = @DPID, [LIFE_SUPPORT] = @LIFE_SUPPORT WHERE [ID] = @original_ID AND (([UserID] = @original_UserID) OR ([UserID] IS NULL AND @original_UserID IS NULL)) AND (([CAMPAINGN_NUMBER] = @original_CAMPAINGN_NUMBER) OR ([CAMPAINGN_NUMBER] IS NULL AND @original_CAMPAINGN_NUMBER IS NULL)) AND (([VERBAL_ACCEPTANCE_NO] = @original_VERBAL_ACCEPTANCE_NO) OR ([VERBAL_ACCEPTANCE_NO] IS NULL AND @original_VERBAL_ACCEPTANCE_NO IS NULL)) AND (([DATE_ACCEPTED] = @original_DATE_ACCEPTED) OR ([DATE_ACCEPTED] IS NULL AND @original_DATE_ACCEPTED IS NULL)) AND (([CALL_TYPE] = @original_CALL_TYPE) OR ([CALL_TYPE] IS NULL AND @original_CALL_TYPE IS NULL)) AND (([FUEL_TYPE] = @original_FUEL_TYPE) OR ([FUEL_TYPE] IS NULL AND @original_FUEL_TYPE IS NULL)) AND (([CUSTOMER_TYPE] = @original_CUSTOMER_TYPE) OR ([CUSTOMER_TYPE] IS NULL AND @original_CUSTOMER_TYPE IS NULL)) AND (([NETWORK_AREA] = @original_NETWORK_AREA) OR ([NETWORK_AREA] IS NULL AND @original_NETWORK_AREA IS NULL)) AND (([OFFER_SELECTION] = @original_OFFER_SELECTION) OR ([OFFER_SELECTION] IS NULL AND @original_OFFER_SELECTION IS NULL)) AND (([PRODUCT_INCENTIVE] = @original_PRODUCT_INCENTIVE) OR ([PRODUCT_INCENTIVE] IS NULL AND @original_PRODUCT_INCENTIVE IS NULL)) AND (([UPFRONT_DISCOUNT] = @original_UPFRONT_DISCOUNT) OR ([UPFRONT_DISCOUNT] IS NULL AND @original_UPFRONT_DISCOUNT IS NULL)) AND (([OFFER_PARTNER] = @original_OFFER_PARTNER) OR ([OFFER_PARTNER] IS NULL AND @original_OFFER_PARTNER IS NULL)) AND (([COMPANY_NAME] = @original_COMPANY_NAME) OR ([COMPANY_NAME] IS NULL AND @original_COMPANY_NAME IS NULL)) AND (([TRADING_NAME] = @original_TRADING_NAME) OR ([TRADING_NAME] IS NULL AND @original_TRADING_NAME IS NULL)) AND (([COMPANY_POSITION] = @original_COMPANY_POSITION) OR ([COMPANY_POSITION] IS NULL AND @original_COMPANY_POSITION IS NULL)) AND (([ABN] = @original_ABN) OR ([ABN] IS NULL AND @original_ABN IS NULL)) AND (([TITLE] = @original_TITLE) OR ([TITLE] IS NULL AND @original_TITLE IS NULL)) AND (([FIRST_NAME] = @original_FIRST_NAME) OR ([FIRST_NAME] IS NULL AND @original_FIRST_NAME IS NULL)) AND (([LAST_NAME] = @original_LAST_NAME) OR ([LAST_NAME] IS NULL AND @original_LAST_NAME IS NULL)) AND (([BILL_NAME_1] = @original_BILL_NAME_1) OR ([BILL_NAME_1] IS NULL AND @original_BILL_NAME_1 IS NULL)) AND (([BILL_NAME_2] = @original_BILL_NAME_2) OR ([BILL_NAME_2] IS NULL AND @original_BILL_NAME_2 IS NULL)) AND (([DOB] = @original_DOB) OR ([DOB] IS NULL AND @original_DOB IS NULL)) AND (([DRIVERS_LICENCE] = @original_DRIVERS_LICENCE) OR ([DRIVERS_LICENCE] IS NULL AND @original_DRIVERS_LICENCE IS NULL)) AND (([HPHONE] = @original_HPHONE) OR ([HPHONE] IS NULL AND @original_HPHONE IS NULL)) AND (([BPHONE] = @original_BPHONE) OR ([BPHONE] IS NULL AND @original_BPHONE IS NULL)) AND (([MOBILE] = @original_MOBILE) OR ([MOBILE] IS NULL AND @original_MOBILE IS NULL)) AND (([EMAIL] = @original_EMAIL) OR ([EMAIL] IS NULL AND @original_EMAIL IS NULL)) AND (([TITLE_CUST_2] = @original_TITLE_CUST_2) OR ([TITLE_CUST_2] IS NULL AND @original_TITLE_CUST_2 IS NULL)) AND (([FIRST_NAME_CUST_2] = @original_FIRST_NAME_CUST_2) OR ([FIRST_NAME_CUST_2] IS NULL AND @original_FIRST_NAME_CUST_2 IS NULL)) AND (([LAST_NAME_CUST_2] = @original_LAST_NAME_CUST_2) OR ([LAST_NAME_CUST_2] IS NULL AND @original_LAST_NAME_CUST_2 IS NULL)) AND (([DOB_CUST_2] = @original_DOB_CUST_2) OR ([DOB_CUST_2] IS NULL AND @original_DOB_CUST_2 IS NULL)) AND (([DRIVERS_LICENCE_CUST_2] = @original_DRIVERS_LICENCE_CUST_2) OR ([DRIVERS_LICENCE_CUST_2] IS NULL AND @original_DRIVERS_LICENCE_CUST_2 IS NULL)) AND (([HPHONE_CUST_2] = @original_HPHONE_CUST_2) OR ([HPHONE_CUST_2] IS NULL AND @original_HPHONE_CUST_2 IS NULL)) AND (([BPHONE_CUST_2] = @original_BPHONE_CUST_2) OR ([BPHONE_CUST_2] IS NULL AND @original_BPHONE_CUST_2 IS NULL)) AND (([MOBILE_CUST_2] = @original_MOBILE_CUST_2) OR ([MOBILE_CUST_2] IS NULL AND @original_MOBILE_CUST_2 IS NULL)) AND (([EMAIL_CUST_2] = @original_EMAIL_CUST_2) OR ([EMAIL_CUST_2] IS NULL AND @original_EMAIL_CUST_2 IS NULL)) AND (([RELATIONSHIP_CODE] = @original_RELATIONSHIP_CODE) OR ([RELATIONSHIP_CODE] IS NULL AND @original_RELATIONSHIP_CODE IS NULL)) AND (([DO_NOT_CONTACT] = @original_DO_NOT_CONTACT) OR ([DO_NOT_CONTACT] IS NULL AND @original_DO_NOT_CONTACT IS NULL)) AND (([SITE_ADD1] = @original_SITE_ADD1) OR ([SITE_ADD1] IS NULL AND @original_SITE_ADD1 IS NULL)) AND (([SITE_SUBURB] = @original_SITE_SUBURB) OR ([SITE_SUBURB] IS NULL AND @original_SITE_SUBURB IS NULL)) AND (([SITE_STATE] = @original_SITE_STATE) OR ([SITE_STATE] IS NULL AND @original_SITE_STATE IS NULL)) AND (([SITE_POSTCODE] = @original_SITE_POSTCODE) OR ([SITE_POSTCODE] IS NULL AND @original_SITE_POSTCODE IS NULL)) AND (([POST_ADDRESS_1] = @original_POST_ADDRESS_1) OR ([POST_ADDRESS_1] IS NULL AND @original_POST_ADDRESS_1 IS NULL)) AND (([POST_ADDRESS_2] = @original_POST_ADDRESS_2) OR ([POST_ADDRESS_2] IS NULL AND @original_POST_ADDRESS_2 IS NULL)) AND (([POST_ADDRESS_3] = @original_POST_ADDRESS_3) OR ([POST_ADDRESS_3] IS NULL AND @original_POST_ADDRESS_3 IS NULL)) AND (([POST_ADDRESS_4] = @original_POST_ADDRESS_4) OR ([POST_ADDRESS_4] IS NULL AND @original_POST_ADDRESS_4 IS NULL)) AND (([POST_SUBURB] = @original_POST_SUBURB) OR ([POST_SUBURB] IS NULL AND @original_POST_SUBURB IS NULL)) AND (([POST_STATE] = @original_POST_STATE) OR ([POST_STATE] IS NULL AND @original_POST_STATE IS NULL)) AND (([POST_POSTCODE] = @original_POST_POSTCODE) OR ([POST_POSTCODE] IS NULL AND @original_POST_POSTCODE IS NULL)) AND (([ACCOUNT_ID] = @original_ACCOUNT_ID) OR ([ACCOUNT_ID] IS NULL AND @original_ACCOUNT_ID IS NULL)) AND (([NMI] = @original_NMI) OR ([NMI] IS NULL AND @original_NMI IS NULL)) AND (([DPI] = @original_DPI) OR ([DPI] IS NULL AND @original_DPI IS NULL)) AND (([CURRENT_ELECTRICITY_RETAILER] = @original_CURRENT_ELECTRICITY_RETAILER) OR ([CURRENT_ELECTRICITY_RETAILER] IS NULL AND @original_CURRENT_ELECTRICITY_RETAILER IS NULL)) AND (([OPERATOR_NAME] = @original_OPERATOR_NAME) OR ([OPERATOR_NAME] IS NULL AND @original_OPERATOR_NAME IS NULL)) AND (([ANNUAL_CONSUMPTION] = @original_ANNUAL_CONSUMPTION) OR ([ANNUAL_CONSUMPTION] IS NULL AND @original_ANNUAL_CONSUMPTION IS NULL)) AND (([OFFER_STATUS] = @original_OFFER_STATUS) OR ([OFFER_STATUS] IS NULL AND @original_OFFER_STATUS IS NULL)) AND (([AFFILIATION_INITIAL] = @original_AFFILIATION_INITIAL) OR ([AFFILIATION_INITIAL] IS NULL AND @original_AFFILIATION_INITIAL IS NULL)) AND (([AFFILIATION_SURNAME] = @original_AFFILIATION_SURNAME) OR ([AFFILIATION_SURNAME] IS NULL AND @original_AFFILIATION_SURNAME IS NULL)) AND (([AFFILIATION_MEMBER_NO] = @original_AFFILIATION_MEMBER_NO) OR ([AFFILIATION_MEMBER_NO] IS NULL AND @original_AFFILIATION_MEMBER_NO IS NULL)) AND (([PAYMENT_OPTION] = @original_PAYMENT_OPTION) OR ([PAYMENT_OPTION] IS NULL AND @original_PAYMENT_OPTION IS NULL)) AND (([SMARTER_PAY_CREDIT] = @original_SMARTER_PAY_CREDIT) OR ([SMARTER_PAY_CREDIT] IS NULL AND @original_SMARTER_PAY_CREDIT IS NULL)) AND (([RPO_FIRST_PAYMENT_DATE] = @original_RPO_FIRST_PAYMENT_DATE) OR ([RPO_FIRST_PAYMENT_DATE] IS NULL AND @original_RPO_FIRST_PAYMENT_DATE IS NULL)) AND (([RPO_ELEC_MONTH] = @original_RPO_ELEC_MONTH) OR ([RPO_ELEC_MONTH] IS NULL AND @original_RPO_ELEC_MONTH IS NULL)) AND (([RPO_ELEC_FORTN] = @original_RPO_ELEC_FORTN) OR ([RPO_ELEC_FORTN] IS NULL AND @original_RPO_ELEC_FORTN IS NULL)) AND (([RPO_GAS_MONTH] = @original_RPO_GAS_MONTH) OR ([RPO_GAS_MONTH] IS NULL AND @original_RPO_GAS_MONTH IS NULL)) AND (([RPO_GAS_FORTN] = @original_RPO_GAS_FORTN) OR ([RPO_GAS_FORTN] IS NULL AND @original_RPO_GAS_FORTN IS NULL)) AND (([RPO_COMB_MONTH] = @original_RPO_COMB_MONTH) OR ([RPO_COMB_MONTH] IS NULL AND @original_RPO_COMB_MONTH IS NULL)) AND (([RPO_COMB_FORTN] = @original_RPO_COMB_FORTN) OR ([RPO_COMB_FORTN] IS NULL AND @original_RPO_COMB_FORTN IS NULL)) AND (([RPO_FREQ_SELECTION] = @original_RPO_FREQ_SELECTION) OR ([RPO_FREQ_SELECTION] IS NULL AND @original_RPO_FREQ_SELECTION IS NULL)) AND (([DD_DETAILS_GIVEN] = @original_DD_DETAILS_GIVEN) OR ([DD_DETAILS_GIVEN] IS NULL AND @original_DD_DETAILS_GIVEN IS NULL)) AND (([PAY_SELECTION] = @original_PAY_SELECTION) OR ([PAY_SELECTION] IS NULL AND @original_PAY_SELECTION IS NULL)) AND (([NAME_FIN_INST] = @original_NAME_FIN_INST) OR ([NAME_FIN_INST] IS NULL AND @original_NAME_FIN_INST IS NULL)) AND (([ACC_HOLDER_NAME] = @original_ACC_HOLDER_NAME) OR ([ACC_HOLDER_NAME] IS NULL AND @original_ACC_HOLDER_NAME IS NULL)) AND (([BSB] = @original_BSB) OR ([BSB] IS NULL AND @original_BSB IS NULL)) AND (([ACCOUNT_NUMBER] = @original_ACCOUNT_NUMBER) OR ([ACCOUNT_NUMBER] IS NULL AND @original_ACCOUNT_NUMBER IS NULL)) AND (([CARD_TYPE] = @original_CARD_TYPE) OR ([CARD_TYPE] IS NULL AND @original_CARD_TYPE IS NULL)) AND (([CARD_NUMBER] = @original_CARD_NUMBER) OR ([CARD_NUMBER] IS NULL AND @original_CARD_NUMBER IS NULL)) AND (([VERIF_NUMBER] = @original_VERIF_NUMBER) OR ([VERIF_NUMBER] IS NULL AND @original_VERIF_NUMBER IS NULL)) AND (([CARD_NAME] = @original_CARD_NAME) OR ([CARD_NAME] IS NULL AND @original_CARD_NAME IS NULL)) AND (([EXPIRY_DATE] = @original_EXPIRY_DATE) OR ([EXPIRY_DATE] IS NULL AND @original_EXPIRY_DATE IS NULL)) AND (([PAYMENT_OPTION_PRIOR_TO_SALE] = @original_PAYMENT_OPTION_PRIOR_TO_SALE) OR ([PAYMENT_OPTION_PRIOR_TO_SALE] IS NULL AND @original_PAYMENT_OPTION_PRIOR_TO_SALE IS NULL)) AND (([SELL_CODE] = @original_SELL_CODE) OR ([SELL_CODE] IS NULL AND @original_SELL_CODE IS NULL)) AND (([VERIFICATION_OPERATOR_COMMENTS] = @original_VERIFICATION_OPERATOR_COMMENTS) OR ([VERIFICATION_OPERATOR_COMMENTS] IS NULL AND @original_VERIFICATION_OPERATOR_COMMENTS IS NULL)) AND (([DOCUMENT_NUMBER] = @original_DOCUMENT_NUMBER) OR ([DOCUMENT_NUMBER] IS NULL AND @original_DOCUMENT_NUMBER IS NULL)) AND (([D2D_REP_NAME_ID] = @original_D2D_REP_NAME_ID) OR ([D2D_REP_NAME_ID] IS NULL AND @original_D2D_REP_NAME_ID IS NULL)) AND (([D2D_AGENCY] = @original_D2D_AGENCY) OR ([D2D_AGENCY] IS NULL AND @original_D2D_AGENCY IS NULL)) AND (([DISCOUNT_PERCENT] = @original_DISCOUNT_PERCENT) OR ([DISCOUNT_PERCENT] IS NULL AND @original_DISCOUNT_PERCENT IS NULL)) AND (([MKT_GREEN_RATIO] = @original_MKT_GREEN_RATIO) OR ([MKT_GREEN_RATIO] IS NULL AND @original_MKT_GREEN_RATIO IS NULL)) AND (([DPID] = @original_DPID) OR ([DPID] IS NULL AND @original_DPID IS NULL)) AND (([LIFE_SUPPORT] = @original_LIFE_SUPPORT) OR ([LIFE_SUPPORT] IS NULL AND @original_LIFE_SUPPORT IS NULL))">
            <DeleteParameters>
                <asp:Parameter Name="original_ID" Type="Int32" />
                <asp:Parameter Name="original_UserID" Type="Int32" />
                <asp:Parameter Name="original_CAMPAINGN_NUMBER" Type="Decimal" />
                <asp:Parameter Name="original_VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DATE_ACCEPTED" />
                <asp:Parameter Name="original_CALL_TYPE" Type="String" />
                <asp:Parameter Name="original_FUEL_TYPE" Type="String" />
                <asp:Parameter Name="original_CUSTOMER_TYPE" Type="String" />
                <asp:Parameter Name="original_NETWORK_AREA" Type="String" />
                <asp:Parameter Name="original_OFFER_SELECTION" Type="String" />
                <asp:Parameter Name="original_PRODUCT_INCENTIVE" Type="String" />
                <asp:Parameter Name="original_UPFRONT_DISCOUNT" Type="Decimal" />
                <asp:Parameter Name="original_OFFER_PARTNER" Type="String" />
                <asp:Parameter Name="original_COMPANY_NAME" Type="String" />
                <asp:Parameter Name="original_TRADING_NAME" Type="String" />
                <asp:Parameter Name="original_COMPANY_POSITION" Type="String" />
                <asp:Parameter Name="original_ABN" Type="String" />
                <asp:Parameter Name="original_TITLE" Type="String" />
                <asp:Parameter Name="original_FIRST_NAME" Type="String" />
                <asp:Parameter Name="original_LAST_NAME" Type="String" />
                <asp:Parameter Name="original_BILL_NAME_1" Type="String" />
                <asp:Parameter Name="original_BILL_NAME_2" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DOB" />
                <asp:Parameter Name="original_DRIVERS_LICENCE" Type="String" />
                <asp:Parameter Name="original_HPHONE" Type="String" />
                <asp:Parameter Name="original_BPHONE" Type="String" />
                <asp:Parameter Name="original_MOBILE" Type="String" />
                <asp:Parameter Name="original_EMAIL" Type="String" />
                <asp:Parameter Name="original_TITLE_CUST_2" Type="String" />
                <asp:Parameter Name="original_FIRST_NAME_CUST_2" Type="String" />
                <asp:Parameter Name="original_LAST_NAME_CUST_2" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DOB_CUST_2" />
                <asp:Parameter Name="original_DRIVERS_LICENCE_CUST_2" Type="String" />
                <asp:Parameter Name="original_HPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="original_BPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="original_MOBILE_CUST_2" Type="String" />
                <asp:Parameter Name="original_EMAIL_CUST_2" Type="String" />
                <asp:Parameter Name="original_RELATIONSHIP_CODE" Type="String" />
                <asp:Parameter Name="original_DO_NOT_CONTACT" Type="String" />
                <asp:Parameter Name="original_SITE_ADD1" Type="String" />
                <asp:Parameter Name="original_SITE_SUBURB" Type="String" />
                <asp:Parameter Name="original_SITE_STATE" Type="String" />
                <asp:Parameter Name="original_SITE_POSTCODE" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_1" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_2" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_3" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_4" Type="String" />
                <asp:Parameter Name="original_POST_SUBURB" Type="String" />
                <asp:Parameter Name="original_POST_STATE" Type="String" />
                <asp:Parameter Name="original_POST_POSTCODE" Type="String" />
                <asp:Parameter Name="original_ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="original_NMI" Type="String" />
                <asp:Parameter Name="original_DPI" Type="String" />
                <asp:Parameter Name="original_CURRENT_ELECTRICITY_RETAILER" Type="String" />
                <asp:Parameter Name="original_OPERATOR_NAME" Type="String" />
                <asp:Parameter Name="original_ANNUAL_CONSUMPTION" Type="Decimal" />
                <asp:Parameter Name="original_OFFER_STATUS" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_INITIAL" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_SURNAME" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_MEMBER_NO" Type="String" />
                <asp:Parameter Name="original_PAYMENT_OPTION" Type="String" />
                <asp:Parameter Name="original_SMARTER_PAY_CREDIT" Type="String" />
                <asp:Parameter DbType="Date" Name="original_RPO_FIRST_PAYMENT_DATE" />
                <asp:Parameter Name="original_RPO_ELEC_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_ELEC_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_GAS_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_GAS_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_COMB_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_COMB_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_FREQ_SELECTION" Type="String" />
                <asp:Parameter Name="original_DD_DETAILS_GIVEN" Type="String" />
                <asp:Parameter Name="original_PAY_SELECTION" Type="String" />
                <asp:Parameter Name="original_NAME_FIN_INST" Type="String" />
                <asp:Parameter Name="original_ACC_HOLDER_NAME" Type="String" />
                <asp:Parameter Name="original_BSB" Type="String" />
                <asp:Parameter Name="original_ACCOUNT_NUMBER" Type="String" />
                <asp:Parameter Name="original_CARD_TYPE" Type="String" />
                <asp:Parameter Name="original_CARD_NUMBER" Type="String" />
                <asp:Parameter Name="original_VERIF_NUMBER" Type="String" />
                <asp:Parameter Name="original_CARD_NAME" Type="String" />
                <asp:Parameter Name="original_EXPIRY_DATE" Type="String" />
                <asp:Parameter Name="original_PAYMENT_OPTION_PRIOR_TO_SALE" Type="String" />
                <asp:Parameter Name="original_SELL_CODE" Type="String" />
                <asp:Parameter Name="original_VERIFICATION_OPERATOR_COMMENTS" Type="String" />
                <asp:Parameter Name="original_DOCUMENT_NUMBER" Type="String" />
                <asp:Parameter Name="original_D2D_REP_NAME_ID" Type="String" />
                <asp:Parameter Name="original_D2D_AGENCY" Type="String" />
                <asp:Parameter Name="original_DISCOUNT_PERCENT" Type="Decimal" />
                <asp:Parameter Name="original_MKT_GREEN_RATIO" Type="Decimal" />
                <asp:Parameter Name="original_DPID" Type="String" />
                <asp:Parameter Name="original_LIFE_SUPPORT" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="UserID" Type="Int32" />
                <asp:Parameter Name="CAMPAINGN_NUMBER" Type="Decimal" />
                <asp:Parameter Name="VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter DbType="Date" Name="DATE_ACCEPTED" />
                <asp:Parameter Name="CALL_TYPE" Type="String" />
                <asp:Parameter Name="FUEL_TYPE" Type="String" />
                <asp:Parameter Name="CUSTOMER_TYPE" Type="String" />
                <asp:Parameter Name="NETWORK_AREA" Type="String" />
                <asp:Parameter Name="OFFER_SELECTION" Type="String" />
                <asp:Parameter Name="PRODUCT_INCENTIVE" Type="String" />
                <asp:Parameter Name="UPFRONT_DISCOUNT" Type="Decimal" />
                <asp:Parameter Name="OFFER_PARTNER" Type="String" />
                <asp:Parameter Name="COMPANY_NAME" Type="String" />
                <asp:Parameter Name="TRADING_NAME" Type="String" />
                <asp:Parameter Name="COMPANY_POSITION" Type="String" />
                <asp:Parameter Name="ABN" Type="String" />
                <asp:Parameter Name="TITLE" Type="String" />
                <asp:Parameter Name="FIRST_NAME" Type="String" />
                <asp:Parameter Name="LAST_NAME" Type="String" />
                <asp:Parameter Name="BILL_NAME_1" Type="String" />
                <asp:Parameter Name="BILL_NAME_2" Type="String" />
                <asp:Parameter DbType="Date" Name="DOB" />
                <asp:Parameter Name="DRIVERS_LICENCE" Type="String" />
                <asp:Parameter Name="HPHONE" Type="String" />
                <asp:Parameter Name="BPHONE" Type="String" />
                <asp:Parameter Name="MOBILE" Type="String" />
                <asp:Parameter Name="EMAIL" Type="String" />
                <asp:Parameter Name="TITLE_CUST_2" Type="String" />
                <asp:Parameter Name="FIRST_NAME_CUST_2" Type="String" />
                <asp:Parameter Name="LAST_NAME_CUST_2" Type="String" />
                <asp:Parameter DbType="Date" Name="DOB_CUST_2" />
                <asp:Parameter Name="DRIVERS_LICENCE_CUST_2" Type="String" />
                <asp:Parameter Name="HPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="BPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="MOBILE_CUST_2" Type="String" />
                <asp:Parameter Name="EMAIL_CUST_2" Type="String" />
                <asp:Parameter Name="RELATIONSHIP_CODE" Type="String" />
                <asp:Parameter Name="DO_NOT_CONTACT" Type="String" />
                <asp:Parameter Name="SITE_ADD1" Type="String" />
                <asp:Parameter Name="SITE_SUBURB" Type="String" />
                <asp:Parameter Name="SITE_STATE" Type="String" />
                <asp:Parameter Name="SITE_POSTCODE" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_1" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_2" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_3" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_4" Type="String" />
                <asp:Parameter Name="POST_SUBURB" Type="String" />
                <asp:Parameter Name="POST_STATE" Type="String" />
                <asp:Parameter Name="POST_POSTCODE" Type="String" />
                <asp:Parameter Name="ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="NMI" Type="String" />
                <asp:Parameter Name="DPI" Type="String" />
                <asp:Parameter Name="CURRENT_ELECTRICITY_RETAILER" Type="String" />
                <asp:Parameter Name="OPERATOR_NAME" Type="String" />
                <asp:Parameter Name="ANNUAL_CONSUMPTION" Type="Decimal" />
                <asp:Parameter Name="OFFER_STATUS" Type="String" />
                <asp:Parameter Name="AFFILIATION_INITIAL" Type="String" />
                <asp:Parameter Name="AFFILIATION_SURNAME" Type="String" />
                <asp:Parameter Name="AFFILIATION_MEMBER_NO" Type="String" />
                <asp:Parameter Name="PAYMENT_OPTION" Type="String" />
                <asp:Parameter Name="SMARTER_PAY_CREDIT" Type="String" />
                <asp:Parameter DbType="Date" Name="RPO_FIRST_PAYMENT_DATE" />
                <asp:Parameter Name="RPO_ELEC_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_ELEC_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_GAS_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_GAS_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_COMB_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_COMB_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_FREQ_SELECTION" Type="String" />
                <asp:Parameter Name="DD_DETAILS_GIVEN" Type="String" />
                <asp:Parameter Name="PAY_SELECTION" Type="String" />
                <asp:Parameter Name="NAME_FIN_INST" Type="String" />
                <asp:Parameter Name="ACC_HOLDER_NAME" Type="String" />
                <asp:Parameter Name="BSB" Type="String" />
                <asp:Parameter Name="ACCOUNT_NUMBER" Type="String" />
                <asp:Parameter Name="CARD_TYPE" Type="String" />
                <asp:Parameter Name="CARD_NUMBER" Type="String" />
                <asp:Parameter Name="VERIF_NUMBER" Type="String" />
                <asp:Parameter Name="CARD_NAME" Type="String" />
                <asp:Parameter Name="EXPIRY_DATE" Type="String" />
                <asp:Parameter Name="PAYMENT_OPTION_PRIOR_TO_SALE" Type="String" />
                <asp:Parameter Name="SELL_CODE" Type="String" />
                <asp:Parameter Name="VERIFICATION_OPERATOR_COMMENTS" Type="String" />
                <asp:Parameter Name="DOCUMENT_NUMBER" Type="String" />
                <asp:Parameter Name="D2D_REP_NAME_ID" Type="String" />
                <asp:Parameter Name="D2D_AGENCY" Type="String" />
                <asp:Parameter Name="DISCOUNT_PERCENT" Type="Decimal" />
                <asp:Parameter Name="MKT_GREEN_RATIO" Type="Decimal" />
                <asp:Parameter Name="DPID" Type="String" />
                <asp:Parameter Name="LIFE_SUPPORT" Type="String" />
            </InsertParameters>
            <SelectParameters>
                <asp:ControlParameter ControlID="GridView3" Name="VERBAL_ACCEPTANCE_NO" 
                    PropertyName="SelectedValue" Type="String" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="UserID" Type="Int32" />
                <asp:Parameter Name="CAMPAINGN_NUMBER" Type="Decimal" />
                <asp:Parameter Name="VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter DbType="Date" Name="DATE_ACCEPTED" />
                <asp:Parameter Name="CALL_TYPE" Type="String" />
                <asp:Parameter Name="FUEL_TYPE" Type="String" />
                <asp:Parameter Name="CUSTOMER_TYPE" Type="String" />
                <asp:Parameter Name="NETWORK_AREA" Type="String" />
                <asp:Parameter Name="OFFER_SELECTION" Type="String" />
                <asp:Parameter Name="PRODUCT_INCENTIVE" Type="String" />
                <asp:Parameter Name="UPFRONT_DISCOUNT" Type="Decimal" />
                <asp:Parameter Name="OFFER_PARTNER" Type="String" />
                <asp:Parameter Name="COMPANY_NAME" Type="String" />
                <asp:Parameter Name="TRADING_NAME" Type="String" />
                <asp:Parameter Name="COMPANY_POSITION" Type="String" />
                <asp:Parameter Name="ABN" Type="String" />
                <asp:Parameter Name="TITLE" Type="String" />
                <asp:Parameter Name="FIRST_NAME" Type="String" />
                <asp:Parameter Name="LAST_NAME" Type="String" />
                <asp:Parameter Name="BILL_NAME_1" Type="String" />
                <asp:Parameter Name="BILL_NAME_2" Type="String" />
                <asp:Parameter DbType="Date" Name="DOB" />
                <asp:Parameter Name="DRIVERS_LICENCE" Type="String" />
                <asp:Parameter Name="HPHONE" Type="String" />
                <asp:Parameter Name="BPHONE" Type="String" />
                <asp:Parameter Name="MOBILE" Type="String" />
                <asp:Parameter Name="EMAIL" Type="String" />
                <asp:Parameter Name="TITLE_CUST_2" Type="String" />
                <asp:Parameter Name="FIRST_NAME_CUST_2" Type="String" />
                <asp:Parameter Name="LAST_NAME_CUST_2" Type="String" />
                <asp:Parameter DbType="Date" Name="DOB_CUST_2" />
                <asp:Parameter Name="DRIVERS_LICENCE_CUST_2" Type="String" />
                <asp:Parameter Name="HPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="BPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="MOBILE_CUST_2" Type="String" />
                <asp:Parameter Name="EMAIL_CUST_2" Type="String" />
                <asp:Parameter Name="RELATIONSHIP_CODE" Type="String" />
                <asp:Parameter Name="DO_NOT_CONTACT" Type="String" />
                <asp:Parameter Name="SITE_ADD1" Type="String" />
                <asp:Parameter Name="SITE_SUBURB" Type="String" />
                <asp:Parameter Name="SITE_STATE" Type="String" />
                <asp:Parameter Name="SITE_POSTCODE" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_1" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_2" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_3" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_4" Type="String" />
                <asp:Parameter Name="POST_SUBURB" Type="String" />
                <asp:Parameter Name="POST_STATE" Type="String" />
                <asp:Parameter Name="POST_POSTCODE" Type="String" />
                <asp:Parameter Name="ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="NMI" Type="String" />
                <asp:Parameter Name="DPI" Type="String" />
                <asp:Parameter Name="CURRENT_ELECTRICITY_RETAILER" Type="String" />
                <asp:Parameter Name="OPERATOR_NAME" Type="String" />
                <asp:Parameter Name="ANNUAL_CONSUMPTION" Type="Decimal" />
                <asp:Parameter Name="OFFER_STATUS" Type="String" />
                <asp:Parameter Name="AFFILIATION_INITIAL" Type="String" />
                <asp:Parameter Name="AFFILIATION_SURNAME" Type="String" />
                <asp:Parameter Name="AFFILIATION_MEMBER_NO" Type="String" />
                <asp:Parameter Name="PAYMENT_OPTION" Type="String" />
                <asp:Parameter Name="SMARTER_PAY_CREDIT" Type="String" />
                <asp:Parameter DbType="Date" Name="RPO_FIRST_PAYMENT_DATE" />
                <asp:Parameter Name="RPO_ELEC_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_ELEC_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_GAS_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_GAS_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_COMB_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_COMB_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_FREQ_SELECTION" Type="String" />
                <asp:Parameter Name="DD_DETAILS_GIVEN" Type="String" />
                <asp:Parameter Name="PAY_SELECTION" Type="String" />
                <asp:Parameter Name="NAME_FIN_INST" Type="String" />
                <asp:Parameter Name="ACC_HOLDER_NAME" Type="String" />
                <asp:Parameter Name="BSB" Type="String" />
                <asp:Parameter Name="ACCOUNT_NUMBER" Type="String" />
                <asp:Parameter Name="CARD_TYPE" Type="String" />
                <asp:Parameter Name="CARD_NUMBER" Type="String" />
                <asp:Parameter Name="VERIF_NUMBER" Type="String" />
                <asp:Parameter Name="CARD_NAME" Type="String" />
                <asp:Parameter Name="EXPIRY_DATE" Type="String" />
                <asp:Parameter Name="PAYMENT_OPTION_PRIOR_TO_SALE" Type="String" />
                <asp:Parameter Name="SELL_CODE" Type="String" />
                <asp:Parameter Name="VERIFICATION_OPERATOR_COMMENTS" Type="String" />
                <asp:Parameter Name="DOCUMENT_NUMBER" Type="String" />
                <asp:Parameter Name="D2D_REP_NAME_ID" Type="String" />
                <asp:Parameter Name="D2D_AGENCY" Type="String" />
                <asp:Parameter Name="DISCOUNT_PERCENT" Type="Decimal" />
                <asp:Parameter Name="MKT_GREEN_RATIO" Type="Decimal" />
                <asp:Parameter Name="DPID" Type="String" />
                <asp:Parameter Name="LIFE_SUPPORT" Type="String" />
                <asp:Parameter Name="original_ID" Type="Int32" />
                <asp:Parameter Name="original_UserID" Type="Int32" />
                <asp:Parameter Name="original_CAMPAINGN_NUMBER" Type="Decimal" />
                <asp:Parameter Name="original_VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DATE_ACCEPTED" />
                <asp:Parameter Name="original_CALL_TYPE" Type="String" />
                <asp:Parameter Name="original_FUEL_TYPE" Type="String" />
                <asp:Parameter Name="original_CUSTOMER_TYPE" Type="String" />
                <asp:Parameter Name="original_NETWORK_AREA" Type="String" />
                <asp:Parameter Name="original_OFFER_SELECTION" Type="String" />
                <asp:Parameter Name="original_PRODUCT_INCENTIVE" Type="String" />
                <asp:Parameter Name="original_UPFRONT_DISCOUNT" Type="Decimal" />
                <asp:Parameter Name="original_OFFER_PARTNER" Type="String" />
                <asp:Parameter Name="original_COMPANY_NAME" Type="String" />
                <asp:Parameter Name="original_TRADING_NAME" Type="String" />
                <asp:Parameter Name="original_COMPANY_POSITION" Type="String" />
                <asp:Parameter Name="original_ABN" Type="String" />
                <asp:Parameter Name="original_TITLE" Type="String" />
                <asp:Parameter Name="original_FIRST_NAME" Type="String" />
                <asp:Parameter Name="original_LAST_NAME" Type="String" />
                <asp:Parameter Name="original_BILL_NAME_1" Type="String" />
                <asp:Parameter Name="original_BILL_NAME_2" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DOB" />
                <asp:Parameter Name="original_DRIVERS_LICENCE" Type="String" />
                <asp:Parameter Name="original_HPHONE" Type="String" />
                <asp:Parameter Name="original_BPHONE" Type="String" />
                <asp:Parameter Name="original_MOBILE" Type="String" />
                <asp:Parameter Name="original_EMAIL" Type="String" />
                <asp:Parameter Name="original_TITLE_CUST_2" Type="String" />
                <asp:Parameter Name="original_FIRST_NAME_CUST_2" Type="String" />
                <asp:Parameter Name="original_LAST_NAME_CUST_2" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DOB_CUST_2" />
                <asp:Parameter Name="original_DRIVERS_LICENCE_CUST_2" Type="String" />
                <asp:Parameter Name="original_HPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="original_BPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="original_MOBILE_CUST_2" Type="String" />
                <asp:Parameter Name="original_EMAIL_CUST_2" Type="String" />
                <asp:Parameter Name="original_RELATIONSHIP_CODE" Type="String" />
                <asp:Parameter Name="original_DO_NOT_CONTACT" Type="String" />
                <asp:Parameter Name="original_SITE_ADD1" Type="String" />
                <asp:Parameter Name="original_SITE_SUBURB" Type="String" />
                <asp:Parameter Name="original_SITE_STATE" Type="String" />
                <asp:Parameter Name="original_SITE_POSTCODE" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_1" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_2" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_3" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_4" Type="String" />
                <asp:Parameter Name="original_POST_SUBURB" Type="String" />
                <asp:Parameter Name="original_POST_STATE" Type="String" />
                <asp:Parameter Name="original_POST_POSTCODE" Type="String" />
                <asp:Parameter Name="original_ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="original_NMI" Type="String" />
                <asp:Parameter Name="original_DPI" Type="String" />
                <asp:Parameter Name="original_CURRENT_ELECTRICITY_RETAILER" Type="String" />
                <asp:Parameter Name="original_OPERATOR_NAME" Type="String" />
                <asp:Parameter Name="original_ANNUAL_CONSUMPTION" Type="Decimal" />
                <asp:Parameter Name="original_OFFER_STATUS" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_INITIAL" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_SURNAME" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_MEMBER_NO" Type="String" />
                <asp:Parameter Name="original_PAYMENT_OPTION" Type="String" />
                <asp:Parameter Name="original_SMARTER_PAY_CREDIT" Type="String" />
                <asp:Parameter DbType="Date" Name="original_RPO_FIRST_PAYMENT_DATE" />
                <asp:Parameter Name="original_RPO_ELEC_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_ELEC_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_GAS_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_GAS_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_COMB_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_COMB_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_FREQ_SELECTION" Type="String" />
                <asp:Parameter Name="original_DD_DETAILS_GIVEN" Type="String" />
                <asp:Parameter Name="original_PAY_SELECTION" Type="String" />
                <asp:Parameter Name="original_NAME_FIN_INST" Type="String" />
                <asp:Parameter Name="original_ACC_HOLDER_NAME" Type="String" />
                <asp:Parameter Name="original_BSB" Type="String" />
                <asp:Parameter Name="original_ACCOUNT_NUMBER" Type="String" />
                <asp:Parameter Name="original_CARD_TYPE" Type="String" />
                <asp:Parameter Name="original_CARD_NUMBER" Type="String" />
                <asp:Parameter Name="original_VERIF_NUMBER" Type="String" />
                <asp:Parameter Name="original_CARD_NAME" Type="String" />
                <asp:Parameter Name="original_EXPIRY_DATE" Type="String" />
                <asp:Parameter Name="original_PAYMENT_OPTION_PRIOR_TO_SALE" Type="String" />
                <asp:Parameter Name="original_SELL_CODE" Type="String" />
                <asp:Parameter Name="original_VERIFICATION_OPERATOR_COMMENTS" Type="String" />
                <asp:Parameter Name="original_DOCUMENT_NUMBER" Type="String" />
                <asp:Parameter Name="original_D2D_REP_NAME_ID" Type="String" />
                <asp:Parameter Name="original_D2D_AGENCY" Type="String" />
                <asp:Parameter Name="original_DISCOUNT_PERCENT" Type="Decimal" />
                <asp:Parameter Name="original_MKT_GREEN_RATIO" Type="Decimal" />
                <asp:Parameter Name="original_DPID" Type="String" />
                <asp:Parameter Name="original_LIFE_SUPPORT" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>

            </asp:View>
            <asp:View ID="View3" runat="server">
            <h2>Energy Australia Cancellation Reject Form</h2>

        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConflictDetection="CompareAllValues" 
            ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>" 
            DeleteCommand="DELETE FROM [tblEACancelReject] WHERE [VERBAL_ACCEPTANCE_NO] = @original_VERBAL_ACCEPTANCE_NO AND (([CHANNEL] = @original_CHANNEL) OR ([CHANNEL] IS NULL AND @original_CHANNEL IS NULL)) AND (([LOAD_NO] = @original_LOAD_NO) OR ([LOAD_NO] IS NULL AND @original_LOAD_NO IS NULL)) AND (([FILE_NAME] = @original_FILE_NAME) OR ([FILE_NAME] IS NULL AND @original_FILE_NAME IS NULL)) AND (([FILE_LINE_NO] = @original_FILE_LINE_NO) OR ([FILE_LINE_NO] IS NULL AND @original_FILE_LINE_NO IS NULL)) AND (([VALIDATION_TYPE] = @original_VALIDATION_TYPE) OR ([VALIDATION_TYPE] IS NULL AND @original_VALIDATION_TYPE IS NULL)) AND (([COMMENTS] = @original_COMMENTS) OR ([COMMENTS] IS NULL AND @original_COMMENTS IS NULL))" 
            InsertCommand="INSERT INTO [tblEACancelReject] ([CHANNEL], [LOAD_NO], [FILE_NAME], [FILE_LINE_NO], [VERBAL_ACCEPTANCE_NO], [VALIDATION_TYPE], [COMMENTS]) VALUES (@CHANNEL, @LOAD_NO, @FILE_NAME, @FILE_LINE_NO, @VERBAL_ACCEPTANCE_NO, @VALIDATION_TYPE, @COMMENTS)" 
            OldValuesParameterFormatString="original_{0}" 
            SelectCommand="SELECT * FROM [tblEACancelReject]" 
            
                    UpdateCommand="UPDATE [tblEACancelReject] SET [CHANNEL] = @CHANNEL, [LOAD_NO] = @LOAD_NO, [FILE_NAME] = @FILE_NAME, [FILE_LINE_NO] = @FILE_LINE_NO, [VALIDATION_TYPE] = @VALIDATION_TYPE, [COMMENTS] = @COMMENTS WHERE [VERBAL_ACCEPTANCE_NO] = @original_VERBAL_ACCEPTANCE_NO AND (([CHANNEL] = @original_CHANNEL) OR ([CHANNEL] IS NULL AND @original_CHANNEL IS NULL)) AND (([LOAD_NO] = @original_LOAD_NO) OR ([LOAD_NO] IS NULL AND @original_LOAD_NO IS NULL)) AND (([FILE_NAME] = @original_FILE_NAME) OR ([FILE_NAME] IS NULL AND @original_FILE_NAME IS NULL)) AND (([FILE_LINE_NO] = @original_FILE_LINE_NO) OR ([FILE_LINE_NO] IS NULL AND @original_FILE_LINE_NO IS NULL)) AND (([VALIDATION_TYPE] = @original_VALIDATION_TYPE) OR ([VALIDATION_TYPE] IS NULL AND @original_VALIDATION_TYPE IS NULL)) AND (([COMMENTS] = @original_COMMENTS) OR ([COMMENTS] IS NULL AND @original_COMMENTS IS NULL))">
            <DeleteParameters>
                <asp:Parameter Name="original_VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter Name="original_CHANNEL" Type="String" />
                <asp:Parameter Name="original_LOAD_NO" Type="Decimal" />
                <asp:Parameter Name="original_FILE_NAME" Type="String" />
                <asp:Parameter Name="original_FILE_LINE_NO" Type="Decimal" />
                <asp:Parameter Name="original_VALIDATION_TYPE" Type="String" />
                <asp:Parameter Name="original_COMMENTS" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="CHANNEL" Type="String" />
                <asp:Parameter Name="LOAD_NO" Type="Decimal" />
                <asp:Parameter Name="FILE_NAME" Type="String" />
                <asp:Parameter Name="FILE_LINE_NO" Type="Decimal" />
                <asp:Parameter Name="VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter Name="VALIDATION_TYPE" Type="String" />
                <asp:Parameter Name="COMMENTS" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="CHANNEL" Type="String" />
                <asp:Parameter Name="LOAD_NO" Type="Decimal" />
                <asp:Parameter Name="FILE_NAME" Type="String" />
                <asp:Parameter Name="FILE_LINE_NO" Type="Decimal" />
                <asp:Parameter Name="VALIDATION_TYPE" Type="String" />
                <asp:Parameter Name="COMMENTS" Type="String" />
                <asp:Parameter Name="original_VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter Name="original_CHANNEL" Type="String" />
                <asp:Parameter Name="original_LOAD_NO" Type="Decimal" />
                <asp:Parameter Name="original_FILE_NAME" Type="String" />
                <asp:Parameter Name="original_FILE_LINE_NO" Type="Decimal" />
                <asp:Parameter Name="original_VALIDATION_TYPE" Type="String" />
                <asp:Parameter Name="original_COMMENTS" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:GridView ID="GridView2" runat="server" AllowPaging="True" CssClass="mGrid"
            PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" 
            AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="VERBAL_ACCEPTANCE_NO" 
            DataSourceID="SqlDataSource2" EnableModelValidation="True">
            <AlternatingRowStyle CssClass="alt"></AlternatingRowStyle>

            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" 
                    ShowSelectButton="True" />
                <asp:BoundField DataField="CHANNEL" HeaderText="CHANNEL" 
                    SortExpression="CHANNEL" />
                <asp:BoundField DataField="LOAD_NO" HeaderText="LOAD_NO" 
                    SortExpression="LOAD_NO" />
                <asp:BoundField DataField="FILE_NAME" HeaderText="FILE_NAME" 
                    SortExpression="FILE_NAME" />
                <asp:BoundField DataField="FILE_LINE_NO" HeaderText="FILE_LINE_NO" 
                    SortExpression="FILE_LINE_NO" />
                <asp:TemplateField HeaderText="VERBAL_ACCEPTANCE_NO" 
                    SortExpression="VERBAL_ACCEPTANCE_NO">
                    <EditItemTemplate>
                        <asp:Label ID="Label1" runat="server" 
                            Text='<%# Eval("VERBAL_ACCEPTANCE_NO") %>'></asp:Label>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" 
                            Text='<%# Bind("VERBAL_ACCEPTANCE_NO") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="VALIDATION_TYPE" HeaderText="VALIDATION_TYPE" 
                    SortExpression="VALIDATION_TYPE" />
                <asp:BoundField DataField="COMMENTS" HeaderText="COMMENTS" 
                    SortExpression="COMMENTS" />
            </Columns>
            <PagerStyle CssClass="pgr" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>" 
            OldValuesParameterFormatString="original_{0}" 
            
            SelectCommand="SELECT * FROM [tblEA] WHERE ([VERBAL_ACCEPTANCE_NO] = @VERBAL_ACCEPTANCE_NO)" 
            ConflictDetection="CompareAllValues" 
            DeleteCommand="DELETE FROM [tblEA] WHERE [ID] = @original_ID AND (([UserID] = @original_UserID) OR ([UserID] IS NULL AND @original_UserID IS NULL)) AND (([CAMPAINGN_NUMBER] = @original_CAMPAINGN_NUMBER) OR ([CAMPAINGN_NUMBER] IS NULL AND @original_CAMPAINGN_NUMBER IS NULL)) AND (([VERBAL_ACCEPTANCE_NO] = @original_VERBAL_ACCEPTANCE_NO) OR ([VERBAL_ACCEPTANCE_NO] IS NULL AND @original_VERBAL_ACCEPTANCE_NO IS NULL)) AND (([DATE_ACCEPTED] = @original_DATE_ACCEPTED) OR ([DATE_ACCEPTED] IS NULL AND @original_DATE_ACCEPTED IS NULL)) AND (([CALL_TYPE] = @original_CALL_TYPE) OR ([CALL_TYPE] IS NULL AND @original_CALL_TYPE IS NULL)) AND (([FUEL_TYPE] = @original_FUEL_TYPE) OR ([FUEL_TYPE] IS NULL AND @original_FUEL_TYPE IS NULL)) AND (([CUSTOMER_TYPE] = @original_CUSTOMER_TYPE) OR ([CUSTOMER_TYPE] IS NULL AND @original_CUSTOMER_TYPE IS NULL)) AND (([NETWORK_AREA] = @original_NETWORK_AREA) OR ([NETWORK_AREA] IS NULL AND @original_NETWORK_AREA IS NULL)) AND (([OFFER_SELECTION] = @original_OFFER_SELECTION) OR ([OFFER_SELECTION] IS NULL AND @original_OFFER_SELECTION IS NULL)) AND (([PRODUCT_INCENTIVE] = @original_PRODUCT_INCENTIVE) OR ([PRODUCT_INCENTIVE] IS NULL AND @original_PRODUCT_INCENTIVE IS NULL)) AND (([UPFRONT_DISCOUNT] = @original_UPFRONT_DISCOUNT) OR ([UPFRONT_DISCOUNT] IS NULL AND @original_UPFRONT_DISCOUNT IS NULL)) AND (([OFFER_PARTNER] = @original_OFFER_PARTNER) OR ([OFFER_PARTNER] IS NULL AND @original_OFFER_PARTNER IS NULL)) AND (([COMPANY_NAME] = @original_COMPANY_NAME) OR ([COMPANY_NAME] IS NULL AND @original_COMPANY_NAME IS NULL)) AND (([TRADING_NAME] = @original_TRADING_NAME) OR ([TRADING_NAME] IS NULL AND @original_TRADING_NAME IS NULL)) AND (([COMPANY_POSITION] = @original_COMPANY_POSITION) OR ([COMPANY_POSITION] IS NULL AND @original_COMPANY_POSITION IS NULL)) AND (([ABN] = @original_ABN) OR ([ABN] IS NULL AND @original_ABN IS NULL)) AND (([TITLE] = @original_TITLE) OR ([TITLE] IS NULL AND @original_TITLE IS NULL)) AND (([FIRST_NAME] = @original_FIRST_NAME) OR ([FIRST_NAME] IS NULL AND @original_FIRST_NAME IS NULL)) AND (([LAST_NAME] = @original_LAST_NAME) OR ([LAST_NAME] IS NULL AND @original_LAST_NAME IS NULL)) AND (([BILL_NAME_1] = @original_BILL_NAME_1) OR ([BILL_NAME_1] IS NULL AND @original_BILL_NAME_1 IS NULL)) AND (([BILL_NAME_2] = @original_BILL_NAME_2) OR ([BILL_NAME_2] IS NULL AND @original_BILL_NAME_2 IS NULL)) AND (([DOB] = @original_DOB) OR ([DOB] IS NULL AND @original_DOB IS NULL)) AND (([DRIVERS_LICENCE] = @original_DRIVERS_LICENCE) OR ([DRIVERS_LICENCE] IS NULL AND @original_DRIVERS_LICENCE IS NULL)) AND (([HPHONE] = @original_HPHONE) OR ([HPHONE] IS NULL AND @original_HPHONE IS NULL)) AND (([BPHONE] = @original_BPHONE) OR ([BPHONE] IS NULL AND @original_BPHONE IS NULL)) AND (([MOBILE] = @original_MOBILE) OR ([MOBILE] IS NULL AND @original_MOBILE IS NULL)) AND (([EMAIL] = @original_EMAIL) OR ([EMAIL] IS NULL AND @original_EMAIL IS NULL)) AND (([TITLE_CUST_2] = @original_TITLE_CUST_2) OR ([TITLE_CUST_2] IS NULL AND @original_TITLE_CUST_2 IS NULL)) AND (([FIRST_NAME_CUST_2] = @original_FIRST_NAME_CUST_2) OR ([FIRST_NAME_CUST_2] IS NULL AND @original_FIRST_NAME_CUST_2 IS NULL)) AND (([LAST_NAME_CUST_2] = @original_LAST_NAME_CUST_2) OR ([LAST_NAME_CUST_2] IS NULL AND @original_LAST_NAME_CUST_2 IS NULL)) AND (([DOB_CUST_2] = @original_DOB_CUST_2) OR ([DOB_CUST_2] IS NULL AND @original_DOB_CUST_2 IS NULL)) AND (([DRIVERS_LICENCE_CUST_2] = @original_DRIVERS_LICENCE_CUST_2) OR ([DRIVERS_LICENCE_CUST_2] IS NULL AND @original_DRIVERS_LICENCE_CUST_2 IS NULL)) AND (([HPHONE_CUST_2] = @original_HPHONE_CUST_2) OR ([HPHONE_CUST_2] IS NULL AND @original_HPHONE_CUST_2 IS NULL)) AND (([BPHONE_CUST_2] = @original_BPHONE_CUST_2) OR ([BPHONE_CUST_2] IS NULL AND @original_BPHONE_CUST_2 IS NULL)) AND (([MOBILE_CUST_2] = @original_MOBILE_CUST_2) OR ([MOBILE_CUST_2] IS NULL AND @original_MOBILE_CUST_2 IS NULL)) AND (([EMAIL_CUST_2] = @original_EMAIL_CUST_2) OR ([EMAIL_CUST_2] IS NULL AND @original_EMAIL_CUST_2 IS NULL)) AND (([RELATIONSHIP_CODE] = @original_RELATIONSHIP_CODE) OR ([RELATIONSHIP_CODE] IS NULL AND @original_RELATIONSHIP_CODE IS NULL)) AND (([DO_NOT_CONTACT] = @original_DO_NOT_CONTACT) OR ([DO_NOT_CONTACT] IS NULL AND @original_DO_NOT_CONTACT IS NULL)) AND (([SITE_ADD1] = @original_SITE_ADD1) OR ([SITE_ADD1] IS NULL AND @original_SITE_ADD1 IS NULL)) AND (([SITE_SUBURB] = @original_SITE_SUBURB) OR ([SITE_SUBURB] IS NULL AND @original_SITE_SUBURB IS NULL)) AND (([SITE_STATE] = @original_SITE_STATE) OR ([SITE_STATE] IS NULL AND @original_SITE_STATE IS NULL)) AND (([SITE_POSTCODE] = @original_SITE_POSTCODE) OR ([SITE_POSTCODE] IS NULL AND @original_SITE_POSTCODE IS NULL)) AND (([POST_ADDRESS_1] = @original_POST_ADDRESS_1) OR ([POST_ADDRESS_1] IS NULL AND @original_POST_ADDRESS_1 IS NULL)) AND (([POST_ADDRESS_2] = @original_POST_ADDRESS_2) OR ([POST_ADDRESS_2] IS NULL AND @original_POST_ADDRESS_2 IS NULL)) AND (([POST_ADDRESS_3] = @original_POST_ADDRESS_3) OR ([POST_ADDRESS_3] IS NULL AND @original_POST_ADDRESS_3 IS NULL)) AND (([POST_ADDRESS_4] = @original_POST_ADDRESS_4) OR ([POST_ADDRESS_4] IS NULL AND @original_POST_ADDRESS_4 IS NULL)) AND (([POST_SUBURB] = @original_POST_SUBURB) OR ([POST_SUBURB] IS NULL AND @original_POST_SUBURB IS NULL)) AND (([POST_STATE] = @original_POST_STATE) OR ([POST_STATE] IS NULL AND @original_POST_STATE IS NULL)) AND (([POST_POSTCODE] = @original_POST_POSTCODE) OR ([POST_POSTCODE] IS NULL AND @original_POST_POSTCODE IS NULL)) AND (([ACCOUNT_ID] = @original_ACCOUNT_ID) OR ([ACCOUNT_ID] IS NULL AND @original_ACCOUNT_ID IS NULL)) AND (([NMI] = @original_NMI) OR ([NMI] IS NULL AND @original_NMI IS NULL)) AND (([DPI] = @original_DPI) OR ([DPI] IS NULL AND @original_DPI IS NULL)) AND (([CURRENT_ELECTRICITY_RETAILER] = @original_CURRENT_ELECTRICITY_RETAILER) OR ([CURRENT_ELECTRICITY_RETAILER] IS NULL AND @original_CURRENT_ELECTRICITY_RETAILER IS NULL)) AND (([OPERATOR_NAME] = @original_OPERATOR_NAME) OR ([OPERATOR_NAME] IS NULL AND @original_OPERATOR_NAME IS NULL)) AND (([ANNUAL_CONSUMPTION] = @original_ANNUAL_CONSUMPTION) OR ([ANNUAL_CONSUMPTION] IS NULL AND @original_ANNUAL_CONSUMPTION IS NULL)) AND (([OFFER_STATUS] = @original_OFFER_STATUS) OR ([OFFER_STATUS] IS NULL AND @original_OFFER_STATUS IS NULL)) AND (([AFFILIATION_INITIAL] = @original_AFFILIATION_INITIAL) OR ([AFFILIATION_INITIAL] IS NULL AND @original_AFFILIATION_INITIAL IS NULL)) AND (([AFFILIATION_SURNAME] = @original_AFFILIATION_SURNAME) OR ([AFFILIATION_SURNAME] IS NULL AND @original_AFFILIATION_SURNAME IS NULL)) AND (([AFFILIATION_MEMBER_NO] = @original_AFFILIATION_MEMBER_NO) OR ([AFFILIATION_MEMBER_NO] IS NULL AND @original_AFFILIATION_MEMBER_NO IS NULL)) AND (([PAYMENT_OPTION] = @original_PAYMENT_OPTION) OR ([PAYMENT_OPTION] IS NULL AND @original_PAYMENT_OPTION IS NULL)) AND (([SMARTER_PAY_CREDIT] = @original_SMARTER_PAY_CREDIT) OR ([SMARTER_PAY_CREDIT] IS NULL AND @original_SMARTER_PAY_CREDIT IS NULL)) AND (([RPO_FIRST_PAYMENT_DATE] = @original_RPO_FIRST_PAYMENT_DATE) OR ([RPO_FIRST_PAYMENT_DATE] IS NULL AND @original_RPO_FIRST_PAYMENT_DATE IS NULL)) AND (([RPO_ELEC_MONTH] = @original_RPO_ELEC_MONTH) OR ([RPO_ELEC_MONTH] IS NULL AND @original_RPO_ELEC_MONTH IS NULL)) AND (([RPO_ELEC_FORTN] = @original_RPO_ELEC_FORTN) OR ([RPO_ELEC_FORTN] IS NULL AND @original_RPO_ELEC_FORTN IS NULL)) AND (([RPO_GAS_MONTH] = @original_RPO_GAS_MONTH) OR ([RPO_GAS_MONTH] IS NULL AND @original_RPO_GAS_MONTH IS NULL)) AND (([RPO_GAS_FORTN] = @original_RPO_GAS_FORTN) OR ([RPO_GAS_FORTN] IS NULL AND @original_RPO_GAS_FORTN IS NULL)) AND (([RPO_COMB_MONTH] = @original_RPO_COMB_MONTH) OR ([RPO_COMB_MONTH] IS NULL AND @original_RPO_COMB_MONTH IS NULL)) AND (([RPO_COMB_FORTN] = @original_RPO_COMB_FORTN) OR ([RPO_COMB_FORTN] IS NULL AND @original_RPO_COMB_FORTN IS NULL)) AND (([RPO_FREQ_SELECTION] = @original_RPO_FREQ_SELECTION) OR ([RPO_FREQ_SELECTION] IS NULL AND @original_RPO_FREQ_SELECTION IS NULL)) AND (([DD_DETAILS_GIVEN] = @original_DD_DETAILS_GIVEN) OR ([DD_DETAILS_GIVEN] IS NULL AND @original_DD_DETAILS_GIVEN IS NULL)) AND (([PAY_SELECTION] = @original_PAY_SELECTION) OR ([PAY_SELECTION] IS NULL AND @original_PAY_SELECTION IS NULL)) AND (([NAME_FIN_INST] = @original_NAME_FIN_INST) OR ([NAME_FIN_INST] IS NULL AND @original_NAME_FIN_INST IS NULL)) AND (([ACC_HOLDER_NAME] = @original_ACC_HOLDER_NAME) OR ([ACC_HOLDER_NAME] IS NULL AND @original_ACC_HOLDER_NAME IS NULL)) AND (([BSB] = @original_BSB) OR ([BSB] IS NULL AND @original_BSB IS NULL)) AND (([ACCOUNT_NUMBER] = @original_ACCOUNT_NUMBER) OR ([ACCOUNT_NUMBER] IS NULL AND @original_ACCOUNT_NUMBER IS NULL)) AND (([CARD_TYPE] = @original_CARD_TYPE) OR ([CARD_TYPE] IS NULL AND @original_CARD_TYPE IS NULL)) AND (([CARD_NUMBER] = @original_CARD_NUMBER) OR ([CARD_NUMBER] IS NULL AND @original_CARD_NUMBER IS NULL)) AND (([VERIF_NUMBER] = @original_VERIF_NUMBER) OR ([VERIF_NUMBER] IS NULL AND @original_VERIF_NUMBER IS NULL)) AND (([CARD_NAME] = @original_CARD_NAME) OR ([CARD_NAME] IS NULL AND @original_CARD_NAME IS NULL)) AND (([EXPIRY_DATE] = @original_EXPIRY_DATE) OR ([EXPIRY_DATE] IS NULL AND @original_EXPIRY_DATE IS NULL)) AND (([PAYMENT_OPTION_PRIOR_TO_SALE] = @original_PAYMENT_OPTION_PRIOR_TO_SALE) OR ([PAYMENT_OPTION_PRIOR_TO_SALE] IS NULL AND @original_PAYMENT_OPTION_PRIOR_TO_SALE IS NULL)) AND (([SELL_CODE] = @original_SELL_CODE) OR ([SELL_CODE] IS NULL AND @original_SELL_CODE IS NULL)) AND (([VERIFICATION_OPERATOR_COMMENTS] = @original_VERIFICATION_OPERATOR_COMMENTS) OR ([VERIFICATION_OPERATOR_COMMENTS] IS NULL AND @original_VERIFICATION_OPERATOR_COMMENTS IS NULL)) AND (([DOCUMENT_NUMBER] = @original_DOCUMENT_NUMBER) OR ([DOCUMENT_NUMBER] IS NULL AND @original_DOCUMENT_NUMBER IS NULL)) AND (([D2D_REP_NAME_ID] = @original_D2D_REP_NAME_ID) OR ([D2D_REP_NAME_ID] IS NULL AND @original_D2D_REP_NAME_ID IS NULL)) AND (([D2D_AGENCY] = @original_D2D_AGENCY) OR ([D2D_AGENCY] IS NULL AND @original_D2D_AGENCY IS NULL)) AND (([DISCOUNT_PERCENT] = @original_DISCOUNT_PERCENT) OR ([DISCOUNT_PERCENT] IS NULL AND @original_DISCOUNT_PERCENT IS NULL)) AND (([MKT_GREEN_RATIO] = @original_MKT_GREEN_RATIO) OR ([MKT_GREEN_RATIO] IS NULL AND @original_MKT_GREEN_RATIO IS NULL)) AND (([DPID] = @original_DPID) OR ([DPID] IS NULL AND @original_DPID IS NULL)) AND (([LIFE_SUPPORT] = @original_LIFE_SUPPORT) OR ([LIFE_SUPPORT] IS NULL AND @original_LIFE_SUPPORT IS NULL))" 
            InsertCommand="INSERT INTO [tblEA] ([UserID], [CAMPAINGN_NUMBER], [VERBAL_ACCEPTANCE_NO], [DATE_ACCEPTED], [CALL_TYPE], [FUEL_TYPE], [CUSTOMER_TYPE], [NETWORK_AREA], [OFFER_SELECTION], [PRODUCT_INCENTIVE], [UPFRONT_DISCOUNT], [OFFER_PARTNER], [COMPANY_NAME], [TRADING_NAME], [COMPANY_POSITION], [ABN], [TITLE], [FIRST_NAME], [LAST_NAME], [BILL_NAME_1], [BILL_NAME_2], [DOB], [DRIVERS_LICENCE], [HPHONE], [BPHONE], [MOBILE], [EMAIL], [TITLE_CUST_2], [FIRST_NAME_CUST_2], [LAST_NAME_CUST_2], [DOB_CUST_2], [DRIVERS_LICENCE_CUST_2], [HPHONE_CUST_2], [BPHONE_CUST_2], [MOBILE_CUST_2], [EMAIL_CUST_2], [RELATIONSHIP_CODE], [DO_NOT_CONTACT], [SITE_ADD1], [SITE_SUBURB], [SITE_STATE], [SITE_POSTCODE], [POST_ADDRESS_1], [POST_ADDRESS_2], [POST_ADDRESS_3], [POST_ADDRESS_4], [POST_SUBURB], [POST_STATE], [POST_POSTCODE], [ACCOUNT_ID], [NMI], [DPI], [CURRENT_ELECTRICITY_RETAILER], [OPERATOR_NAME], [ANNUAL_CONSUMPTION], [OFFER_STATUS], [AFFILIATION_INITIAL], [AFFILIATION_SURNAME], [AFFILIATION_MEMBER_NO], [PAYMENT_OPTION], [SMARTER_PAY_CREDIT], [RPO_FIRST_PAYMENT_DATE], [RPO_ELEC_MONTH], [RPO_ELEC_FORTN], [RPO_GAS_MONTH], [RPO_GAS_FORTN], [RPO_COMB_MONTH], [RPO_COMB_FORTN], [RPO_FREQ_SELECTION], [DD_DETAILS_GIVEN], [PAY_SELECTION], [NAME_FIN_INST], [ACC_HOLDER_NAME], [BSB], [ACCOUNT_NUMBER], [CARD_TYPE], [CARD_NUMBER], [VERIF_NUMBER], [CARD_NAME], [EXPIRY_DATE], [PAYMENT_OPTION_PRIOR_TO_SALE], [SELL_CODE], [VERIFICATION_OPERATOR_COMMENTS], [DOCUMENT_NUMBER], [D2D_REP_NAME_ID], [D2D_AGENCY], [DISCOUNT_PERCENT], [MKT_GREEN_RATIO], [DPID], [LIFE_SUPPORT]) VALUES (@UserID, @CAMPAINGN_NUMBER, @VERBAL_ACCEPTANCE_NO, @DATE_ACCEPTED, @CALL_TYPE, @FUEL_TYPE, @CUSTOMER_TYPE, @NETWORK_AREA, @OFFER_SELECTION, @PRODUCT_INCENTIVE, @UPFRONT_DISCOUNT, @OFFER_PARTNER, @COMPANY_NAME, @TRADING_NAME, @COMPANY_POSITION, @ABN, @TITLE, @FIRST_NAME, @LAST_NAME, @BILL_NAME_1, @BILL_NAME_2, @DOB, @DRIVERS_LICENCE, @HPHONE, @BPHONE, @MOBILE, @EMAIL, @TITLE_CUST_2, @FIRST_NAME_CUST_2, @LAST_NAME_CUST_2, @DOB_CUST_2, @DRIVERS_LICENCE_CUST_2, @HPHONE_CUST_2, @BPHONE_CUST_2, @MOBILE_CUST_2, @EMAIL_CUST_2, @RELATIONSHIP_CODE, @DO_NOT_CONTACT, @SITE_ADD1, @SITE_SUBURB, @SITE_STATE, @SITE_POSTCODE, @POST_ADDRESS_1, @POST_ADDRESS_2, @POST_ADDRESS_3, @POST_ADDRESS_4, @POST_SUBURB, @POST_STATE, @POST_POSTCODE, @ACCOUNT_ID, @NMI, @DPI, @CURRENT_ELECTRICITY_RETAILER, @OPERATOR_NAME, @ANNUAL_CONSUMPTION, @OFFER_STATUS, @AFFILIATION_INITIAL, @AFFILIATION_SURNAME, @AFFILIATION_MEMBER_NO, @PAYMENT_OPTION, @SMARTER_PAY_CREDIT, @RPO_FIRST_PAYMENT_DATE, @RPO_ELEC_MONTH, @RPO_ELEC_FORTN, @RPO_GAS_MONTH, @RPO_GAS_FORTN, @RPO_COMB_MONTH, @RPO_COMB_FORTN, @RPO_FREQ_SELECTION, @DD_DETAILS_GIVEN, @PAY_SELECTION, @NAME_FIN_INST, @ACC_HOLDER_NAME, @BSB, @ACCOUNT_NUMBER, @CARD_TYPE, @CARD_NUMBER, @VERIF_NUMBER, @CARD_NAME, @EXPIRY_DATE, @PAYMENT_OPTION_PRIOR_TO_SALE, @SELL_CODE, @VERIFICATION_OPERATOR_COMMENTS, @DOCUMENT_NUMBER, @D2D_REP_NAME_ID, @D2D_AGENCY, @DISCOUNT_PERCENT, @MKT_GREEN_RATIO, @DPID, @LIFE_SUPPORT)" 
            UpdateCommand="UPDATE [tblEA] SET [UserID] = @UserID, [CAMPAINGN_NUMBER] = @CAMPAINGN_NUMBER, [VERBAL_ACCEPTANCE_NO] = @VERBAL_ACCEPTANCE_NO, [DATE_ACCEPTED] = @DATE_ACCEPTED, [CALL_TYPE] = @CALL_TYPE, [FUEL_TYPE] = @FUEL_TYPE, [CUSTOMER_TYPE] = @CUSTOMER_TYPE, [NETWORK_AREA] = @NETWORK_AREA, [OFFER_SELECTION] = @OFFER_SELECTION, [PRODUCT_INCENTIVE] = @PRODUCT_INCENTIVE, [UPFRONT_DISCOUNT] = @UPFRONT_DISCOUNT, [OFFER_PARTNER] = @OFFER_PARTNER, [COMPANY_NAME] = @COMPANY_NAME, [TRADING_NAME] = @TRADING_NAME, [COMPANY_POSITION] = @COMPANY_POSITION, [ABN] = @ABN, [TITLE] = @TITLE, [FIRST_NAME] = @FIRST_NAME, [LAST_NAME] = @LAST_NAME, [BILL_NAME_1] = @BILL_NAME_1, [BILL_NAME_2] = @BILL_NAME_2, [DOB] = @DOB, [DRIVERS_LICENCE] = @DRIVERS_LICENCE, [HPHONE] = @HPHONE, [BPHONE] = @BPHONE, [MOBILE] = @MOBILE, [EMAIL] = @EMAIL, [TITLE_CUST_2] = @TITLE_CUST_2, [FIRST_NAME_CUST_2] = @FIRST_NAME_CUST_2, [LAST_NAME_CUST_2] = @LAST_NAME_CUST_2, [DOB_CUST_2] = @DOB_CUST_2, [DRIVERS_LICENCE_CUST_2] = @DRIVERS_LICENCE_CUST_2, [HPHONE_CUST_2] = @HPHONE_CUST_2, [BPHONE_CUST_2] = @BPHONE_CUST_2, [MOBILE_CUST_2] = @MOBILE_CUST_2, [EMAIL_CUST_2] = @EMAIL_CUST_2, [RELATIONSHIP_CODE] = @RELATIONSHIP_CODE, [DO_NOT_CONTACT] = @DO_NOT_CONTACT, [SITE_ADD1] = @SITE_ADD1, [SITE_SUBURB] = @SITE_SUBURB, [SITE_STATE] = @SITE_STATE, [SITE_POSTCODE] = @SITE_POSTCODE, [POST_ADDRESS_1] = @POST_ADDRESS_1, [POST_ADDRESS_2] = @POST_ADDRESS_2, [POST_ADDRESS_3] = @POST_ADDRESS_3, [POST_ADDRESS_4] = @POST_ADDRESS_4, [POST_SUBURB] = @POST_SUBURB, [POST_STATE] = @POST_STATE, [POST_POSTCODE] = @POST_POSTCODE, [ACCOUNT_ID] = @ACCOUNT_ID, [NMI] = @NMI, [DPI] = @DPI, [CURRENT_ELECTRICITY_RETAILER] = @CURRENT_ELECTRICITY_RETAILER, [OPERATOR_NAME] = @OPERATOR_NAME, [ANNUAL_CONSUMPTION] = @ANNUAL_CONSUMPTION, [OFFER_STATUS] = @OFFER_STATUS, [AFFILIATION_INITIAL] = @AFFILIATION_INITIAL, [AFFILIATION_SURNAME] = @AFFILIATION_SURNAME, [AFFILIATION_MEMBER_NO] = @AFFILIATION_MEMBER_NO, [PAYMENT_OPTION] = @PAYMENT_OPTION, [SMARTER_PAY_CREDIT] = @SMARTER_PAY_CREDIT, [RPO_FIRST_PAYMENT_DATE] = @RPO_FIRST_PAYMENT_DATE, [RPO_ELEC_MONTH] = @RPO_ELEC_MONTH, [RPO_ELEC_FORTN] = @RPO_ELEC_FORTN, [RPO_GAS_MONTH] = @RPO_GAS_MONTH, [RPO_GAS_FORTN] = @RPO_GAS_FORTN, [RPO_COMB_MONTH] = @RPO_COMB_MONTH, [RPO_COMB_FORTN] = @RPO_COMB_FORTN, [RPO_FREQ_SELECTION] = @RPO_FREQ_SELECTION, [DD_DETAILS_GIVEN] = @DD_DETAILS_GIVEN, [PAY_SELECTION] = @PAY_SELECTION, [NAME_FIN_INST] = @NAME_FIN_INST, [ACC_HOLDER_NAME] = @ACC_HOLDER_NAME, [BSB] = @BSB, [ACCOUNT_NUMBER] = @ACCOUNT_NUMBER, [CARD_TYPE] = @CARD_TYPE, [CARD_NUMBER] = @CARD_NUMBER, [VERIF_NUMBER] = @VERIF_NUMBER, [CARD_NAME] = @CARD_NAME, [EXPIRY_DATE] = @EXPIRY_DATE, [PAYMENT_OPTION_PRIOR_TO_SALE] = @PAYMENT_OPTION_PRIOR_TO_SALE, [SELL_CODE] = @SELL_CODE, [VERIFICATION_OPERATOR_COMMENTS] = @VERIFICATION_OPERATOR_COMMENTS, [DOCUMENT_NUMBER] = @DOCUMENT_NUMBER, [D2D_REP_NAME_ID] = @D2D_REP_NAME_ID, [D2D_AGENCY] = @D2D_AGENCY, [DISCOUNT_PERCENT] = @DISCOUNT_PERCENT, [MKT_GREEN_RATIO] = @MKT_GREEN_RATIO, [DPID] = @DPID, [LIFE_SUPPORT] = @LIFE_SUPPORT WHERE [ID] = @original_ID AND (([UserID] = @original_UserID) OR ([UserID] IS NULL AND @original_UserID IS NULL)) AND (([CAMPAINGN_NUMBER] = @original_CAMPAINGN_NUMBER) OR ([CAMPAINGN_NUMBER] IS NULL AND @original_CAMPAINGN_NUMBER IS NULL)) AND (([VERBAL_ACCEPTANCE_NO] = @original_VERBAL_ACCEPTANCE_NO) OR ([VERBAL_ACCEPTANCE_NO] IS NULL AND @original_VERBAL_ACCEPTANCE_NO IS NULL)) AND (([DATE_ACCEPTED] = @original_DATE_ACCEPTED) OR ([DATE_ACCEPTED] IS NULL AND @original_DATE_ACCEPTED IS NULL)) AND (([CALL_TYPE] = @original_CALL_TYPE) OR ([CALL_TYPE] IS NULL AND @original_CALL_TYPE IS NULL)) AND (([FUEL_TYPE] = @original_FUEL_TYPE) OR ([FUEL_TYPE] IS NULL AND @original_FUEL_TYPE IS NULL)) AND (([CUSTOMER_TYPE] = @original_CUSTOMER_TYPE) OR ([CUSTOMER_TYPE] IS NULL AND @original_CUSTOMER_TYPE IS NULL)) AND (([NETWORK_AREA] = @original_NETWORK_AREA) OR ([NETWORK_AREA] IS NULL AND @original_NETWORK_AREA IS NULL)) AND (([OFFER_SELECTION] = @original_OFFER_SELECTION) OR ([OFFER_SELECTION] IS NULL AND @original_OFFER_SELECTION IS NULL)) AND (([PRODUCT_INCENTIVE] = @original_PRODUCT_INCENTIVE) OR ([PRODUCT_INCENTIVE] IS NULL AND @original_PRODUCT_INCENTIVE IS NULL)) AND (([UPFRONT_DISCOUNT] = @original_UPFRONT_DISCOUNT) OR ([UPFRONT_DISCOUNT] IS NULL AND @original_UPFRONT_DISCOUNT IS NULL)) AND (([OFFER_PARTNER] = @original_OFFER_PARTNER) OR ([OFFER_PARTNER] IS NULL AND @original_OFFER_PARTNER IS NULL)) AND (([COMPANY_NAME] = @original_COMPANY_NAME) OR ([COMPANY_NAME] IS NULL AND @original_COMPANY_NAME IS NULL)) AND (([TRADING_NAME] = @original_TRADING_NAME) OR ([TRADING_NAME] IS NULL AND @original_TRADING_NAME IS NULL)) AND (([COMPANY_POSITION] = @original_COMPANY_POSITION) OR ([COMPANY_POSITION] IS NULL AND @original_COMPANY_POSITION IS NULL)) AND (([ABN] = @original_ABN) OR ([ABN] IS NULL AND @original_ABN IS NULL)) AND (([TITLE] = @original_TITLE) OR ([TITLE] IS NULL AND @original_TITLE IS NULL)) AND (([FIRST_NAME] = @original_FIRST_NAME) OR ([FIRST_NAME] IS NULL AND @original_FIRST_NAME IS NULL)) AND (([LAST_NAME] = @original_LAST_NAME) OR ([LAST_NAME] IS NULL AND @original_LAST_NAME IS NULL)) AND (([BILL_NAME_1] = @original_BILL_NAME_1) OR ([BILL_NAME_1] IS NULL AND @original_BILL_NAME_1 IS NULL)) AND (([BILL_NAME_2] = @original_BILL_NAME_2) OR ([BILL_NAME_2] IS NULL AND @original_BILL_NAME_2 IS NULL)) AND (([DOB] = @original_DOB) OR ([DOB] IS NULL AND @original_DOB IS NULL)) AND (([DRIVERS_LICENCE] = @original_DRIVERS_LICENCE) OR ([DRIVERS_LICENCE] IS NULL AND @original_DRIVERS_LICENCE IS NULL)) AND (([HPHONE] = @original_HPHONE) OR ([HPHONE] IS NULL AND @original_HPHONE IS NULL)) AND (([BPHONE] = @original_BPHONE) OR ([BPHONE] IS NULL AND @original_BPHONE IS NULL)) AND (([MOBILE] = @original_MOBILE) OR ([MOBILE] IS NULL AND @original_MOBILE IS NULL)) AND (([EMAIL] = @original_EMAIL) OR ([EMAIL] IS NULL AND @original_EMAIL IS NULL)) AND (([TITLE_CUST_2] = @original_TITLE_CUST_2) OR ([TITLE_CUST_2] IS NULL AND @original_TITLE_CUST_2 IS NULL)) AND (([FIRST_NAME_CUST_2] = @original_FIRST_NAME_CUST_2) OR ([FIRST_NAME_CUST_2] IS NULL AND @original_FIRST_NAME_CUST_2 IS NULL)) AND (([LAST_NAME_CUST_2] = @original_LAST_NAME_CUST_2) OR ([LAST_NAME_CUST_2] IS NULL AND @original_LAST_NAME_CUST_2 IS NULL)) AND (([DOB_CUST_2] = @original_DOB_CUST_2) OR ([DOB_CUST_2] IS NULL AND @original_DOB_CUST_2 IS NULL)) AND (([DRIVERS_LICENCE_CUST_2] = @original_DRIVERS_LICENCE_CUST_2) OR ([DRIVERS_LICENCE_CUST_2] IS NULL AND @original_DRIVERS_LICENCE_CUST_2 IS NULL)) AND (([HPHONE_CUST_2] = @original_HPHONE_CUST_2) OR ([HPHONE_CUST_2] IS NULL AND @original_HPHONE_CUST_2 IS NULL)) AND (([BPHONE_CUST_2] = @original_BPHONE_CUST_2) OR ([BPHONE_CUST_2] IS NULL AND @original_BPHONE_CUST_2 IS NULL)) AND (([MOBILE_CUST_2] = @original_MOBILE_CUST_2) OR ([MOBILE_CUST_2] IS NULL AND @original_MOBILE_CUST_2 IS NULL)) AND (([EMAIL_CUST_2] = @original_EMAIL_CUST_2) OR ([EMAIL_CUST_2] IS NULL AND @original_EMAIL_CUST_2 IS NULL)) AND (([RELATIONSHIP_CODE] = @original_RELATIONSHIP_CODE) OR ([RELATIONSHIP_CODE] IS NULL AND @original_RELATIONSHIP_CODE IS NULL)) AND (([DO_NOT_CONTACT] = @original_DO_NOT_CONTACT) OR ([DO_NOT_CONTACT] IS NULL AND @original_DO_NOT_CONTACT IS NULL)) AND (([SITE_ADD1] = @original_SITE_ADD1) OR ([SITE_ADD1] IS NULL AND @original_SITE_ADD1 IS NULL)) AND (([SITE_SUBURB] = @original_SITE_SUBURB) OR ([SITE_SUBURB] IS NULL AND @original_SITE_SUBURB IS NULL)) AND (([SITE_STATE] = @original_SITE_STATE) OR ([SITE_STATE] IS NULL AND @original_SITE_STATE IS NULL)) AND (([SITE_POSTCODE] = @original_SITE_POSTCODE) OR ([SITE_POSTCODE] IS NULL AND @original_SITE_POSTCODE IS NULL)) AND (([POST_ADDRESS_1] = @original_POST_ADDRESS_1) OR ([POST_ADDRESS_1] IS NULL AND @original_POST_ADDRESS_1 IS NULL)) AND (([POST_ADDRESS_2] = @original_POST_ADDRESS_2) OR ([POST_ADDRESS_2] IS NULL AND @original_POST_ADDRESS_2 IS NULL)) AND (([POST_ADDRESS_3] = @original_POST_ADDRESS_3) OR ([POST_ADDRESS_3] IS NULL AND @original_POST_ADDRESS_3 IS NULL)) AND (([POST_ADDRESS_4] = @original_POST_ADDRESS_4) OR ([POST_ADDRESS_4] IS NULL AND @original_POST_ADDRESS_4 IS NULL)) AND (([POST_SUBURB] = @original_POST_SUBURB) OR ([POST_SUBURB] IS NULL AND @original_POST_SUBURB IS NULL)) AND (([POST_STATE] = @original_POST_STATE) OR ([POST_STATE] IS NULL AND @original_POST_STATE IS NULL)) AND (([POST_POSTCODE] = @original_POST_POSTCODE) OR ([POST_POSTCODE] IS NULL AND @original_POST_POSTCODE IS NULL)) AND (([ACCOUNT_ID] = @original_ACCOUNT_ID) OR ([ACCOUNT_ID] IS NULL AND @original_ACCOUNT_ID IS NULL)) AND (([NMI] = @original_NMI) OR ([NMI] IS NULL AND @original_NMI IS NULL)) AND (([DPI] = @original_DPI) OR ([DPI] IS NULL AND @original_DPI IS NULL)) AND (([CURRENT_ELECTRICITY_RETAILER] = @original_CURRENT_ELECTRICITY_RETAILER) OR ([CURRENT_ELECTRICITY_RETAILER] IS NULL AND @original_CURRENT_ELECTRICITY_RETAILER IS NULL)) AND (([OPERATOR_NAME] = @original_OPERATOR_NAME) OR ([OPERATOR_NAME] IS NULL AND @original_OPERATOR_NAME IS NULL)) AND (([ANNUAL_CONSUMPTION] = @original_ANNUAL_CONSUMPTION) OR ([ANNUAL_CONSUMPTION] IS NULL AND @original_ANNUAL_CONSUMPTION IS NULL)) AND (([OFFER_STATUS] = @original_OFFER_STATUS) OR ([OFFER_STATUS] IS NULL AND @original_OFFER_STATUS IS NULL)) AND (([AFFILIATION_INITIAL] = @original_AFFILIATION_INITIAL) OR ([AFFILIATION_INITIAL] IS NULL AND @original_AFFILIATION_INITIAL IS NULL)) AND (([AFFILIATION_SURNAME] = @original_AFFILIATION_SURNAME) OR ([AFFILIATION_SURNAME] IS NULL AND @original_AFFILIATION_SURNAME IS NULL)) AND (([AFFILIATION_MEMBER_NO] = @original_AFFILIATION_MEMBER_NO) OR ([AFFILIATION_MEMBER_NO] IS NULL AND @original_AFFILIATION_MEMBER_NO IS NULL)) AND (([PAYMENT_OPTION] = @original_PAYMENT_OPTION) OR ([PAYMENT_OPTION] IS NULL AND @original_PAYMENT_OPTION IS NULL)) AND (([SMARTER_PAY_CREDIT] = @original_SMARTER_PAY_CREDIT) OR ([SMARTER_PAY_CREDIT] IS NULL AND @original_SMARTER_PAY_CREDIT IS NULL)) AND (([RPO_FIRST_PAYMENT_DATE] = @original_RPO_FIRST_PAYMENT_DATE) OR ([RPO_FIRST_PAYMENT_DATE] IS NULL AND @original_RPO_FIRST_PAYMENT_DATE IS NULL)) AND (([RPO_ELEC_MONTH] = @original_RPO_ELEC_MONTH) OR ([RPO_ELEC_MONTH] IS NULL AND @original_RPO_ELEC_MONTH IS NULL)) AND (([RPO_ELEC_FORTN] = @original_RPO_ELEC_FORTN) OR ([RPO_ELEC_FORTN] IS NULL AND @original_RPO_ELEC_FORTN IS NULL)) AND (([RPO_GAS_MONTH] = @original_RPO_GAS_MONTH) OR ([RPO_GAS_MONTH] IS NULL AND @original_RPO_GAS_MONTH IS NULL)) AND (([RPO_GAS_FORTN] = @original_RPO_GAS_FORTN) OR ([RPO_GAS_FORTN] IS NULL AND @original_RPO_GAS_FORTN IS NULL)) AND (([RPO_COMB_MONTH] = @original_RPO_COMB_MONTH) OR ([RPO_COMB_MONTH] IS NULL AND @original_RPO_COMB_MONTH IS NULL)) AND (([RPO_COMB_FORTN] = @original_RPO_COMB_FORTN) OR ([RPO_COMB_FORTN] IS NULL AND @original_RPO_COMB_FORTN IS NULL)) AND (([RPO_FREQ_SELECTION] = @original_RPO_FREQ_SELECTION) OR ([RPO_FREQ_SELECTION] IS NULL AND @original_RPO_FREQ_SELECTION IS NULL)) AND (([DD_DETAILS_GIVEN] = @original_DD_DETAILS_GIVEN) OR ([DD_DETAILS_GIVEN] IS NULL AND @original_DD_DETAILS_GIVEN IS NULL)) AND (([PAY_SELECTION] = @original_PAY_SELECTION) OR ([PAY_SELECTION] IS NULL AND @original_PAY_SELECTION IS NULL)) AND (([NAME_FIN_INST] = @original_NAME_FIN_INST) OR ([NAME_FIN_INST] IS NULL AND @original_NAME_FIN_INST IS NULL)) AND (([ACC_HOLDER_NAME] = @original_ACC_HOLDER_NAME) OR ([ACC_HOLDER_NAME] IS NULL AND @original_ACC_HOLDER_NAME IS NULL)) AND (([BSB] = @original_BSB) OR ([BSB] IS NULL AND @original_BSB IS NULL)) AND (([ACCOUNT_NUMBER] = @original_ACCOUNT_NUMBER) OR ([ACCOUNT_NUMBER] IS NULL AND @original_ACCOUNT_NUMBER IS NULL)) AND (([CARD_TYPE] = @original_CARD_TYPE) OR ([CARD_TYPE] IS NULL AND @original_CARD_TYPE IS NULL)) AND (([CARD_NUMBER] = @original_CARD_NUMBER) OR ([CARD_NUMBER] IS NULL AND @original_CARD_NUMBER IS NULL)) AND (([VERIF_NUMBER] = @original_VERIF_NUMBER) OR ([VERIF_NUMBER] IS NULL AND @original_VERIF_NUMBER IS NULL)) AND (([CARD_NAME] = @original_CARD_NAME) OR ([CARD_NAME] IS NULL AND @original_CARD_NAME IS NULL)) AND (([EXPIRY_DATE] = @original_EXPIRY_DATE) OR ([EXPIRY_DATE] IS NULL AND @original_EXPIRY_DATE IS NULL)) AND (([PAYMENT_OPTION_PRIOR_TO_SALE] = @original_PAYMENT_OPTION_PRIOR_TO_SALE) OR ([PAYMENT_OPTION_PRIOR_TO_SALE] IS NULL AND @original_PAYMENT_OPTION_PRIOR_TO_SALE IS NULL)) AND (([SELL_CODE] = @original_SELL_CODE) OR ([SELL_CODE] IS NULL AND @original_SELL_CODE IS NULL)) AND (([VERIFICATION_OPERATOR_COMMENTS] = @original_VERIFICATION_OPERATOR_COMMENTS) OR ([VERIFICATION_OPERATOR_COMMENTS] IS NULL AND @original_VERIFICATION_OPERATOR_COMMENTS IS NULL)) AND (([DOCUMENT_NUMBER] = @original_DOCUMENT_NUMBER) OR ([DOCUMENT_NUMBER] IS NULL AND @original_DOCUMENT_NUMBER IS NULL)) AND (([D2D_REP_NAME_ID] = @original_D2D_REP_NAME_ID) OR ([D2D_REP_NAME_ID] IS NULL AND @original_D2D_REP_NAME_ID IS NULL)) AND (([D2D_AGENCY] = @original_D2D_AGENCY) OR ([D2D_AGENCY] IS NULL AND @original_D2D_AGENCY IS NULL)) AND (([DISCOUNT_PERCENT] = @original_DISCOUNT_PERCENT) OR ([DISCOUNT_PERCENT] IS NULL AND @original_DISCOUNT_PERCENT IS NULL)) AND (([MKT_GREEN_RATIO] = @original_MKT_GREEN_RATIO) OR ([MKT_GREEN_RATIO] IS NULL AND @original_MKT_GREEN_RATIO IS NULL)) AND (([DPID] = @original_DPID) OR ([DPID] IS NULL AND @original_DPID IS NULL)) AND (([LIFE_SUPPORT] = @original_LIFE_SUPPORT) OR ([LIFE_SUPPORT] IS NULL AND @original_LIFE_SUPPORT IS NULL))">
            <DeleteParameters>
                <asp:Parameter Name="original_ID" Type="Int32" />
                <asp:Parameter Name="original_UserID" Type="Int32" />
                <asp:Parameter Name="original_CAMPAINGN_NUMBER" Type="Decimal" />
                <asp:Parameter Name="original_VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DATE_ACCEPTED" />
                <asp:Parameter Name="original_CALL_TYPE" Type="String" />
                <asp:Parameter Name="original_FUEL_TYPE" Type="String" />
                <asp:Parameter Name="original_CUSTOMER_TYPE" Type="String" />
                <asp:Parameter Name="original_NETWORK_AREA" Type="String" />
                <asp:Parameter Name="original_OFFER_SELECTION" Type="String" />
                <asp:Parameter Name="original_PRODUCT_INCENTIVE" Type="String" />
                <asp:Parameter Name="original_UPFRONT_DISCOUNT" Type="Decimal" />
                <asp:Parameter Name="original_OFFER_PARTNER" Type="String" />
                <asp:Parameter Name="original_COMPANY_NAME" Type="String" />
                <asp:Parameter Name="original_TRADING_NAME" Type="String" />
                <asp:Parameter Name="original_COMPANY_POSITION" Type="String" />
                <asp:Parameter Name="original_ABN" Type="String" />
                <asp:Parameter Name="original_TITLE" Type="String" />
                <asp:Parameter Name="original_FIRST_NAME" Type="String" />
                <asp:Parameter Name="original_LAST_NAME" Type="String" />
                <asp:Parameter Name="original_BILL_NAME_1" Type="String" />
                <asp:Parameter Name="original_BILL_NAME_2" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DOB" />
                <asp:Parameter Name="original_DRIVERS_LICENCE" Type="String" />
                <asp:Parameter Name="original_HPHONE" Type="String" />
                <asp:Parameter Name="original_BPHONE" Type="String" />
                <asp:Parameter Name="original_MOBILE" Type="String" />
                <asp:Parameter Name="original_EMAIL" Type="String" />
                <asp:Parameter Name="original_TITLE_CUST_2" Type="String" />
                <asp:Parameter Name="original_FIRST_NAME_CUST_2" Type="String" />
                <asp:Parameter Name="original_LAST_NAME_CUST_2" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DOB_CUST_2" />
                <asp:Parameter Name="original_DRIVERS_LICENCE_CUST_2" Type="String" />
                <asp:Parameter Name="original_HPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="original_BPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="original_MOBILE_CUST_2" Type="String" />
                <asp:Parameter Name="original_EMAIL_CUST_2" Type="String" />
                <asp:Parameter Name="original_RELATIONSHIP_CODE" Type="String" />
                <asp:Parameter Name="original_DO_NOT_CONTACT" Type="String" />
                <asp:Parameter Name="original_SITE_ADD1" Type="String" />
                <asp:Parameter Name="original_SITE_SUBURB" Type="String" />
                <asp:Parameter Name="original_SITE_STATE" Type="String" />
                <asp:Parameter Name="original_SITE_POSTCODE" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_1" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_2" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_3" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_4" Type="String" />
                <asp:Parameter Name="original_POST_SUBURB" Type="String" />
                <asp:Parameter Name="original_POST_STATE" Type="String" />
                <asp:Parameter Name="original_POST_POSTCODE" Type="String" />
                <asp:Parameter Name="original_ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="original_NMI" Type="String" />
                <asp:Parameter Name="original_DPI" Type="String" />
                <asp:Parameter Name="original_CURRENT_ELECTRICITY_RETAILER" Type="String" />
                <asp:Parameter Name="original_OPERATOR_NAME" Type="String" />
                <asp:Parameter Name="original_ANNUAL_CONSUMPTION" Type="Decimal" />
                <asp:Parameter Name="original_OFFER_STATUS" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_INITIAL" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_SURNAME" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_MEMBER_NO" Type="String" />
                <asp:Parameter Name="original_PAYMENT_OPTION" Type="String" />
                <asp:Parameter Name="original_SMARTER_PAY_CREDIT" Type="String" />
                <asp:Parameter DbType="Date" Name="original_RPO_FIRST_PAYMENT_DATE" />
                <asp:Parameter Name="original_RPO_ELEC_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_ELEC_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_GAS_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_GAS_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_COMB_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_COMB_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_FREQ_SELECTION" Type="String" />
                <asp:Parameter Name="original_DD_DETAILS_GIVEN" Type="String" />
                <asp:Parameter Name="original_PAY_SELECTION" Type="String" />
                <asp:Parameter Name="original_NAME_FIN_INST" Type="String" />
                <asp:Parameter Name="original_ACC_HOLDER_NAME" Type="String" />
                <asp:Parameter Name="original_BSB" Type="String" />
                <asp:Parameter Name="original_ACCOUNT_NUMBER" Type="String" />
                <asp:Parameter Name="original_CARD_TYPE" Type="String" />
                <asp:Parameter Name="original_CARD_NUMBER" Type="String" />
                <asp:Parameter Name="original_VERIF_NUMBER" Type="String" />
                <asp:Parameter Name="original_CARD_NAME" Type="String" />
                <asp:Parameter Name="original_EXPIRY_DATE" Type="String" />
                <asp:Parameter Name="original_PAYMENT_OPTION_PRIOR_TO_SALE" Type="String" />
                <asp:Parameter Name="original_SELL_CODE" Type="String" />
                <asp:Parameter Name="original_VERIFICATION_OPERATOR_COMMENTS" Type="String" />
                <asp:Parameter Name="original_DOCUMENT_NUMBER" Type="String" />
                <asp:Parameter Name="original_D2D_REP_NAME_ID" Type="String" />
                <asp:Parameter Name="original_D2D_AGENCY" Type="String" />
                <asp:Parameter Name="original_DISCOUNT_PERCENT" Type="Decimal" />
                <asp:Parameter Name="original_MKT_GREEN_RATIO" Type="Decimal" />
                <asp:Parameter Name="original_DPID" Type="String" />
                <asp:Parameter Name="original_LIFE_SUPPORT" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="UserID" Type="Int32" />
                <asp:Parameter Name="CAMPAINGN_NUMBER" Type="Decimal" />
                <asp:Parameter Name="VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter DbType="Date" Name="DATE_ACCEPTED" />
                <asp:Parameter Name="CALL_TYPE" Type="String" />
                <asp:Parameter Name="FUEL_TYPE" Type="String" />
                <asp:Parameter Name="CUSTOMER_TYPE" Type="String" />
                <asp:Parameter Name="NETWORK_AREA" Type="String" />
                <asp:Parameter Name="OFFER_SELECTION" Type="String" />
                <asp:Parameter Name="PRODUCT_INCENTIVE" Type="String" />
                <asp:Parameter Name="UPFRONT_DISCOUNT" Type="Decimal" />
                <asp:Parameter Name="OFFER_PARTNER" Type="String" />
                <asp:Parameter Name="COMPANY_NAME" Type="String" />
                <asp:Parameter Name="TRADING_NAME" Type="String" />
                <asp:Parameter Name="COMPANY_POSITION" Type="String" />
                <asp:Parameter Name="ABN" Type="String" />
                <asp:Parameter Name="TITLE" Type="String" />
                <asp:Parameter Name="FIRST_NAME" Type="String" />
                <asp:Parameter Name="LAST_NAME" Type="String" />
                <asp:Parameter Name="BILL_NAME_1" Type="String" />
                <asp:Parameter Name="BILL_NAME_2" Type="String" />
                <asp:Parameter DbType="Date" Name="DOB" />
                <asp:Parameter Name="DRIVERS_LICENCE" Type="String" />
                <asp:Parameter Name="HPHONE" Type="String" />
                <asp:Parameter Name="BPHONE" Type="String" />
                <asp:Parameter Name="MOBILE" Type="String" />
                <asp:Parameter Name="EMAIL" Type="String" />
                <asp:Parameter Name="TITLE_CUST_2" Type="String" />
                <asp:Parameter Name="FIRST_NAME_CUST_2" Type="String" />
                <asp:Parameter Name="LAST_NAME_CUST_2" Type="String" />
                <asp:Parameter DbType="Date" Name="DOB_CUST_2" />
                <asp:Parameter Name="DRIVERS_LICENCE_CUST_2" Type="String" />
                <asp:Parameter Name="HPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="BPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="MOBILE_CUST_2" Type="String" />
                <asp:Parameter Name="EMAIL_CUST_2" Type="String" />
                <asp:Parameter Name="RELATIONSHIP_CODE" Type="String" />
                <asp:Parameter Name="DO_NOT_CONTACT" Type="String" />
                <asp:Parameter Name="SITE_ADD1" Type="String" />
                <asp:Parameter Name="SITE_SUBURB" Type="String" />
                <asp:Parameter Name="SITE_STATE" Type="String" />
                <asp:Parameter Name="SITE_POSTCODE" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_1" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_2" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_3" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_4" Type="String" />
                <asp:Parameter Name="POST_SUBURB" Type="String" />
                <asp:Parameter Name="POST_STATE" Type="String" />
                <asp:Parameter Name="POST_POSTCODE" Type="String" />
                <asp:Parameter Name="ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="NMI" Type="String" />
                <asp:Parameter Name="DPI" Type="String" />
                <asp:Parameter Name="CURRENT_ELECTRICITY_RETAILER" Type="String" />
                <asp:Parameter Name="OPERATOR_NAME" Type="String" />
                <asp:Parameter Name="ANNUAL_CONSUMPTION" Type="Decimal" />
                <asp:Parameter Name="OFFER_STATUS" Type="String" />
                <asp:Parameter Name="AFFILIATION_INITIAL" Type="String" />
                <asp:Parameter Name="AFFILIATION_SURNAME" Type="String" />
                <asp:Parameter Name="AFFILIATION_MEMBER_NO" Type="String" />
                <asp:Parameter Name="PAYMENT_OPTION" Type="String" />
                <asp:Parameter Name="SMARTER_PAY_CREDIT" Type="String" />
                <asp:Parameter DbType="Date" Name="RPO_FIRST_PAYMENT_DATE" />
                <asp:Parameter Name="RPO_ELEC_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_ELEC_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_GAS_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_GAS_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_COMB_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_COMB_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_FREQ_SELECTION" Type="String" />
                <asp:Parameter Name="DD_DETAILS_GIVEN" Type="String" />
                <asp:Parameter Name="PAY_SELECTION" Type="String" />
                <asp:Parameter Name="NAME_FIN_INST" Type="String" />
                <asp:Parameter Name="ACC_HOLDER_NAME" Type="String" />
                <asp:Parameter Name="BSB" Type="String" />
                <asp:Parameter Name="ACCOUNT_NUMBER" Type="String" />
                <asp:Parameter Name="CARD_TYPE" Type="String" />
                <asp:Parameter Name="CARD_NUMBER" Type="String" />
                <asp:Parameter Name="VERIF_NUMBER" Type="String" />
                <asp:Parameter Name="CARD_NAME" Type="String" />
                <asp:Parameter Name="EXPIRY_DATE" Type="String" />
                <asp:Parameter Name="PAYMENT_OPTION_PRIOR_TO_SALE" Type="String" />
                <asp:Parameter Name="SELL_CODE" Type="String" />
                <asp:Parameter Name="VERIFICATION_OPERATOR_COMMENTS" Type="String" />
                <asp:Parameter Name="DOCUMENT_NUMBER" Type="String" />
                <asp:Parameter Name="D2D_REP_NAME_ID" Type="String" />
                <asp:Parameter Name="D2D_AGENCY" Type="String" />
                <asp:Parameter Name="DISCOUNT_PERCENT" Type="Decimal" />
                <asp:Parameter Name="MKT_GREEN_RATIO" Type="Decimal" />
                <asp:Parameter Name="DPID" Type="String" />
                <asp:Parameter Name="LIFE_SUPPORT" Type="String" />
            </InsertParameters>
            <SelectParameters>
                <asp:ControlParameter ControlID="GridView2" Name="VERBAL_ACCEPTANCE_NO" 
                    PropertyName="SelectedValue" Type="String" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="UserID" Type="Int32" />
                <asp:Parameter Name="CAMPAINGN_NUMBER" Type="Decimal" />
                <asp:Parameter Name="VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter DbType="Date" Name="DATE_ACCEPTED" />
                <asp:Parameter Name="CALL_TYPE" Type="String" />
                <asp:Parameter Name="FUEL_TYPE" Type="String" />
                <asp:Parameter Name="CUSTOMER_TYPE" Type="String" />
                <asp:Parameter Name="NETWORK_AREA" Type="String" />
                <asp:Parameter Name="OFFER_SELECTION" Type="String" />
                <asp:Parameter Name="PRODUCT_INCENTIVE" Type="String" />
                <asp:Parameter Name="UPFRONT_DISCOUNT" Type="Decimal" />
                <asp:Parameter Name="OFFER_PARTNER" Type="String" />
                <asp:Parameter Name="COMPANY_NAME" Type="String" />
                <asp:Parameter Name="TRADING_NAME" Type="String" />
                <asp:Parameter Name="COMPANY_POSITION" Type="String" />
                <asp:Parameter Name="ABN" Type="String" />
                <asp:Parameter Name="TITLE" Type="String" />
                <asp:Parameter Name="FIRST_NAME" Type="String" />
                <asp:Parameter Name="LAST_NAME" Type="String" />
                <asp:Parameter Name="BILL_NAME_1" Type="String" />
                <asp:Parameter Name="BILL_NAME_2" Type="String" />
                <asp:Parameter DbType="Date" Name="DOB" />
                <asp:Parameter Name="DRIVERS_LICENCE" Type="String" />
                <asp:Parameter Name="HPHONE" Type="String" />
                <asp:Parameter Name="BPHONE" Type="String" />
                <asp:Parameter Name="MOBILE" Type="String" />
                <asp:Parameter Name="EMAIL" Type="String" />
                <asp:Parameter Name="TITLE_CUST_2" Type="String" />
                <asp:Parameter Name="FIRST_NAME_CUST_2" Type="String" />
                <asp:Parameter Name="LAST_NAME_CUST_2" Type="String" />
                <asp:Parameter DbType="Date" Name="DOB_CUST_2" />
                <asp:Parameter Name="DRIVERS_LICENCE_CUST_2" Type="String" />
                <asp:Parameter Name="HPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="BPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="MOBILE_CUST_2" Type="String" />
                <asp:Parameter Name="EMAIL_CUST_2" Type="String" />
                <asp:Parameter Name="RELATIONSHIP_CODE" Type="String" />
                <asp:Parameter Name="DO_NOT_CONTACT" Type="String" />
                <asp:Parameter Name="SITE_ADD1" Type="String" />
                <asp:Parameter Name="SITE_SUBURB" Type="String" />
                <asp:Parameter Name="SITE_STATE" Type="String" />
                <asp:Parameter Name="SITE_POSTCODE" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_1" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_2" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_3" Type="String" />
                <asp:Parameter Name="POST_ADDRESS_4" Type="String" />
                <asp:Parameter Name="POST_SUBURB" Type="String" />
                <asp:Parameter Name="POST_STATE" Type="String" />
                <asp:Parameter Name="POST_POSTCODE" Type="String" />
                <asp:Parameter Name="ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="NMI" Type="String" />
                <asp:Parameter Name="DPI" Type="String" />
                <asp:Parameter Name="CURRENT_ELECTRICITY_RETAILER" Type="String" />
                <asp:Parameter Name="OPERATOR_NAME" Type="String" />
                <asp:Parameter Name="ANNUAL_CONSUMPTION" Type="Decimal" />
                <asp:Parameter Name="OFFER_STATUS" Type="String" />
                <asp:Parameter Name="AFFILIATION_INITIAL" Type="String" />
                <asp:Parameter Name="AFFILIATION_SURNAME" Type="String" />
                <asp:Parameter Name="AFFILIATION_MEMBER_NO" Type="String" />
                <asp:Parameter Name="PAYMENT_OPTION" Type="String" />
                <asp:Parameter Name="SMARTER_PAY_CREDIT" Type="String" />
                <asp:Parameter DbType="Date" Name="RPO_FIRST_PAYMENT_DATE" />
                <asp:Parameter Name="RPO_ELEC_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_ELEC_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_GAS_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_GAS_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_COMB_MONTH" Type="Decimal" />
                <asp:Parameter Name="RPO_COMB_FORTN" Type="Decimal" />
                <asp:Parameter Name="RPO_FREQ_SELECTION" Type="String" />
                <asp:Parameter Name="DD_DETAILS_GIVEN" Type="String" />
                <asp:Parameter Name="PAY_SELECTION" Type="String" />
                <asp:Parameter Name="NAME_FIN_INST" Type="String" />
                <asp:Parameter Name="ACC_HOLDER_NAME" Type="String" />
                <asp:Parameter Name="BSB" Type="String" />
                <asp:Parameter Name="ACCOUNT_NUMBER" Type="String" />
                <asp:Parameter Name="CARD_TYPE" Type="String" />
                <asp:Parameter Name="CARD_NUMBER" Type="String" />
                <asp:Parameter Name="VERIF_NUMBER" Type="String" />
                <asp:Parameter Name="CARD_NAME" Type="String" />
                <asp:Parameter Name="EXPIRY_DATE" Type="String" />
                <asp:Parameter Name="PAYMENT_OPTION_PRIOR_TO_SALE" Type="String" />
                <asp:Parameter Name="SELL_CODE" Type="String" />
                <asp:Parameter Name="VERIFICATION_OPERATOR_COMMENTS" Type="String" />
                <asp:Parameter Name="DOCUMENT_NUMBER" Type="String" />
                <asp:Parameter Name="D2D_REP_NAME_ID" Type="String" />
                <asp:Parameter Name="D2D_AGENCY" Type="String" />
                <asp:Parameter Name="DISCOUNT_PERCENT" Type="Decimal" />
                <asp:Parameter Name="MKT_GREEN_RATIO" Type="Decimal" />
                <asp:Parameter Name="DPID" Type="String" />
                <asp:Parameter Name="LIFE_SUPPORT" Type="String" />
                <asp:Parameter Name="original_ID" Type="Int32" />
                <asp:Parameter Name="original_UserID" Type="Int32" />
                <asp:Parameter Name="original_CAMPAINGN_NUMBER" Type="Decimal" />
                <asp:Parameter Name="original_VERBAL_ACCEPTANCE_NO" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DATE_ACCEPTED" />
                <asp:Parameter Name="original_CALL_TYPE" Type="String" />
                <asp:Parameter Name="original_FUEL_TYPE" Type="String" />
                <asp:Parameter Name="original_CUSTOMER_TYPE" Type="String" />
                <asp:Parameter Name="original_NETWORK_AREA" Type="String" />
                <asp:Parameter Name="original_OFFER_SELECTION" Type="String" />
                <asp:Parameter Name="original_PRODUCT_INCENTIVE" Type="String" />
                <asp:Parameter Name="original_UPFRONT_DISCOUNT" Type="Decimal" />
                <asp:Parameter Name="original_OFFER_PARTNER" Type="String" />
                <asp:Parameter Name="original_COMPANY_NAME" Type="String" />
                <asp:Parameter Name="original_TRADING_NAME" Type="String" />
                <asp:Parameter Name="original_COMPANY_POSITION" Type="String" />
                <asp:Parameter Name="original_ABN" Type="String" />
                <asp:Parameter Name="original_TITLE" Type="String" />
                <asp:Parameter Name="original_FIRST_NAME" Type="String" />
                <asp:Parameter Name="original_LAST_NAME" Type="String" />
                <asp:Parameter Name="original_BILL_NAME_1" Type="String" />
                <asp:Parameter Name="original_BILL_NAME_2" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DOB" />
                <asp:Parameter Name="original_DRIVERS_LICENCE" Type="String" />
                <asp:Parameter Name="original_HPHONE" Type="String" />
                <asp:Parameter Name="original_BPHONE" Type="String" />
                <asp:Parameter Name="original_MOBILE" Type="String" />
                <asp:Parameter Name="original_EMAIL" Type="String" />
                <asp:Parameter Name="original_TITLE_CUST_2" Type="String" />
                <asp:Parameter Name="original_FIRST_NAME_CUST_2" Type="String" />
                <asp:Parameter Name="original_LAST_NAME_CUST_2" Type="String" />
                <asp:Parameter DbType="Date" Name="original_DOB_CUST_2" />
                <asp:Parameter Name="original_DRIVERS_LICENCE_CUST_2" Type="String" />
                <asp:Parameter Name="original_HPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="original_BPHONE_CUST_2" Type="String" />
                <asp:Parameter Name="original_MOBILE_CUST_2" Type="String" />
                <asp:Parameter Name="original_EMAIL_CUST_2" Type="String" />
                <asp:Parameter Name="original_RELATIONSHIP_CODE" Type="String" />
                <asp:Parameter Name="original_DO_NOT_CONTACT" Type="String" />
                <asp:Parameter Name="original_SITE_ADD1" Type="String" />
                <asp:Parameter Name="original_SITE_SUBURB" Type="String" />
                <asp:Parameter Name="original_SITE_STATE" Type="String" />
                <asp:Parameter Name="original_SITE_POSTCODE" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_1" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_2" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_3" Type="String" />
                <asp:Parameter Name="original_POST_ADDRESS_4" Type="String" />
                <asp:Parameter Name="original_POST_SUBURB" Type="String" />
                <asp:Parameter Name="original_POST_STATE" Type="String" />
                <asp:Parameter Name="original_POST_POSTCODE" Type="String" />
                <asp:Parameter Name="original_ACCOUNT_ID" Type="String" />
                <asp:Parameter Name="original_NMI" Type="String" />
                <asp:Parameter Name="original_DPI" Type="String" />
                <asp:Parameter Name="original_CURRENT_ELECTRICITY_RETAILER" Type="String" />
                <asp:Parameter Name="original_OPERATOR_NAME" Type="String" />
                <asp:Parameter Name="original_ANNUAL_CONSUMPTION" Type="Decimal" />
                <asp:Parameter Name="original_OFFER_STATUS" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_INITIAL" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_SURNAME" Type="String" />
                <asp:Parameter Name="original_AFFILIATION_MEMBER_NO" Type="String" />
                <asp:Parameter Name="original_PAYMENT_OPTION" Type="String" />
                <asp:Parameter Name="original_SMARTER_PAY_CREDIT" Type="String" />
                <asp:Parameter DbType="Date" Name="original_RPO_FIRST_PAYMENT_DATE" />
                <asp:Parameter Name="original_RPO_ELEC_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_ELEC_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_GAS_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_GAS_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_COMB_MONTH" Type="Decimal" />
                <asp:Parameter Name="original_RPO_COMB_FORTN" Type="Decimal" />
                <asp:Parameter Name="original_RPO_FREQ_SELECTION" Type="String" />
                <asp:Parameter Name="original_DD_DETAILS_GIVEN" Type="String" />
                <asp:Parameter Name="original_PAY_SELECTION" Type="String" />
                <asp:Parameter Name="original_NAME_FIN_INST" Type="String" />
                <asp:Parameter Name="original_ACC_HOLDER_NAME" Type="String" />
                <asp:Parameter Name="original_BSB" Type="String" />
                <asp:Parameter Name="original_ACCOUNT_NUMBER" Type="String" />
                <asp:Parameter Name="original_CARD_TYPE" Type="String" />
                <asp:Parameter Name="original_CARD_NUMBER" Type="String" />
                <asp:Parameter Name="original_VERIF_NUMBER" Type="String" />
                <asp:Parameter Name="original_CARD_NAME" Type="String" />
                <asp:Parameter Name="original_EXPIRY_DATE" Type="String" />
                <asp:Parameter Name="original_PAYMENT_OPTION_PRIOR_TO_SALE" Type="String" />
                <asp:Parameter Name="original_SELL_CODE" Type="String" />
                <asp:Parameter Name="original_VERIFICATION_OPERATOR_COMMENTS" Type="String" />
                <asp:Parameter Name="original_DOCUMENT_NUMBER" Type="String" />
                <asp:Parameter Name="original_D2D_REP_NAME_ID" Type="String" />
                <asp:Parameter Name="original_D2D_AGENCY" Type="String" />
                <asp:Parameter Name="original_DISCOUNT_PERCENT" Type="Decimal" />
                <asp:Parameter Name="original_MKT_GREEN_RATIO" Type="Decimal" />
                <asp:Parameter Name="original_DPID" Type="String" />
                <asp:Parameter Name="original_LIFE_SUPPORT" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>



            </asp:View>
        </asp:MultiView>

        <asp:DetailsView ID="DetailsView2" runat="Server" CellPadding="4" ForeColor="#333333"
                        GridLines="None" DataSourceID="SqlDataSource4"  AutoGenerateRows="False"
                        DataKeyNames="ID" DefaultMode="Edit" CssClass="mGrid"
                        PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" 
                            EnableModelValidation="True">
                        <AlternatingRowStyle CssClass="alt"></AlternatingRowStyle>


                            <Fields>


                                <asp:TemplateField HeaderText="ID" SortExpression="ID">
                                    <EditItemTemplate>
                                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("ID") %>'></asp:Label>
                                    </EditItemTemplate>
                                    <InsertItemTemplate>
                                        <asp:TextBox ID="TextBox79" runat="server" Text='<%# Bind("ID") %>'></asp:TextBox>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="Label79" runat="server" Text='<%# Bind("ID") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="UserID" SortExpression="UserID">
                                    <EditItemTemplate>
                                        <asp:Label ID="lblUserID" runat="server" Text='<%# Bind("UserID") %>'></asp:Label>
                                    </EditItemTemplate>
                                    <InsertItemTemplate>
                                        <asp:TextBox ID="TextBox80" runat="server" Text='<%# Bind("UserID") %>'></asp:TextBox>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="Label80" runat="server" Text='<%# Bind("UserID") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Campaign Number" 
                                    SortExpression="CAMPAINGN_NUMBER">

                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelCAMPAINGN_NUMBER" runat="server" 
                                            SelectedValue='<%# Bind("CAMPAINGN_NUMBER") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="15797">15797</asp:ListItem><asp:ListItem Value="15798">15798</asp:ListItem><asp:ListItem Value="15799">15799</asp:ListItem><asp:ListItem Value="15800">15800</asp:ListItem><asp:ListItem Value="15801">15801</asp:ListItem>
                                        </asp:DropDownList>

                                        <asp:RequiredFieldValidator ID="CAMPAINGN_NUMBERVali" runat="server" 
                                            ControlToValidate="SelCAMPAINGN_NUMBER" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Verbal Acceptance Number" 
                                    SortExpression="VERBAL_ACCEPTANCE_NO">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="VERBAL_ACCEPTANCE_NO" runat="server" Text='<%# Bind("VERBAL_ACCEPTANCE_NO") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="VERBAL_ACCEPTANCE_NOVali" runat="server" 
                                            ControlToValidate="VERBAL_ACCEPTANCE_NO" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator ID="VERBAL_ACCEPTANCE_NORE" runat="server" 
                                            ErrorMessage="XXXZZZZZZZ9 format(e.g. SSE00000001 XXX:Sale Channel Prefix ZZZZZZZ9:8 digits M1:Optional SME Multi-site No. )" 
                                            ControlToValidate="VERBAL_ACCEPTANCE_NO" ValidationExpression="^[a-zA-Z]{3}\d{8}"></asp:RegularExpressionValidator>

                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Date Accepted" SortExpression="DATE_ACCEPTED">
                                    <ItemTemplate>
                                        <asp:Label ID="Label5" runat="server" Text='<%# Bind("DATE_ACCEPTED") %>'></asp:Label>
                                    </ItemTemplate>


                                <EditItemTemplate>

                                   
                                    <asp:TextBox ID="DATE_ACCEPTED" runat="server" onclick="WdatePicker()" 
                                        Text='<%# Bind("DATE_ACCEPTED") %>' ></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="DATE_ACCEPTEDVali" runat="server" 
                                            ControlToValidate="DATE_ACCEPTED" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>


                                </EditItemTemplate>
                                    <InsertItemTemplate>
                                        <asp:TextBox ID="DATE_ACCEPTED" runat="server" Text='<%# Bind("DATE_ACCEPTED") %>'></asp:TextBox>
                                    </InsertItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Call Type" SortExpression="CALL_TYPE">

                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelCALL_TYPE" runat="server" 
                                            SelectedValue='<%# Bind("CALL_TYPE") %>' onchange="SelCUSTOMER_TYPEChanged()">

                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="D2D">D2D Varification Campaign</asp:ListItem>
                                            <asp:ListItem Value="INBOUND">Telesales Inbound</asp:ListItem>
                                            <asp:ListItem Value="OUTBOUND">Telesales Outbound</asp:ListItem>

                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="CALL_TYPEVali" runat="server" 
                                            ControlToValidate="SelCALL_TYPE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                     
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Fuel Type" SortExpression="FUEL_TYPE">

                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelFuelType" runat="server" 
                                            SelectedValue='<%# Bind("FUEL_TYPE") %>' onchange="FuelTypeChanged()">
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="ELEC_ONLY">Electricity Only Products</asp:ListItem>
                                            <asp:ListItem Value="GAS_ONLY">Gas Only Products</asp:ListItem>
                                            <asp:ListItem Value="DUAL_FUEL">Dual Fuel Products</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" 
                                            ControlToValidate="SelFuelType" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Customer Type" SortExpression="CUSTOMER_TYPE">
                
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelCUSTOMER_TYPE" runat="server" 
                                            SelectedValue='<%# Bind("CUSTOMER_TYPE") %>' onchange="SelCUSTOMER_TYPEChanged()">
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="SME">SME</asp:ListItem>
                                            <asp:ListItem Value="RESD">RESD</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="SelCUSTOMER_TYPEVali" runat="server" 
                                            ControlToValidate="SelCUSTOMER_TYPE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                        <asp:DropDownList ID="SelSOHO" runat="server" onchange="SelCUSTOMER_TYPEChanged()" >
                                            <asp:ListItem Selected="True" value="Not SOHO">Not SOHO</asp:ListItem>
                                            <asp:ListItem value="SOHO">SOHO</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:Label ID="lblCUSTOMER_TYPE" runat="server" Text="Please Fill in Company Name, Position, ABN and Email (Mandatory)" />

                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Network Area" SortExpression="NETWORK_AREA">
   
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelNetArea" runat="server" SelectedValue='<%# Bind("NETWORK_AREA") %>'>
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="AGL">AGL</asp:ListItem>
                                        <asp:ListItem Value="Alinta">Alinta</asp:ListItem>
                                        <asp:ListItem Value="Aurora Energy Pty Ltd">Aurora Energy Pty Ltd</asp:ListItem>
                                        <asp:ListItem Value="Australian Power and Gas">Australian Power and Gas</asp:ListItem>
                                        <asp:ListItem Value="Click Energy">Click Energy</asp:ListItem>
                                        <asp:ListItem Value="Cogent Energy">Cogent Energy</asp:ListItem>
                                        <asp:ListItem Value="Country Energy">Country Energy</asp:ListItem> 
                                        <asp:ListItem Value="Delta Electricity">Delta Electricity</asp:ListItem>
                                        <asp:ListItem Value="Diamond Energy">Diamond Energy</asp:ListItem>
                                        <asp:ListItem Value="Dodo Power & Gas">Dodo Power & Gas</asp:ListItem>
                                        <asp:ListItem Value="Essential Energy">Essential Energy</asp:ListItem>
                                        <asp:ListItem Value="Energy Australia">Energy Australia</asp:ListItem>
                                        <asp:ListItem Value="Ergon Energy Queensland">Ergon Energy Queensland</asp:ListItem>
                                        <asp:ListItem Value="ERM Power Retail Pty Ltd">ERM Power Retail Pty Ltd</asp:ListItem>
                                        <asp:ListItem Value="Eraring Energy">Eraring Energy</asp:ListItem>
                                        <asp:ListItem Value="Essential Energy">Essential Energy</asp:ListItem>
                                        <asp:ListItem Value="Flinders Power Holding GmbH">Flinders Power Holding GmbH</asp:ListItem>
                                        <asp:ListItem Value="GridX Pty Ltd">GridX Pty Ltd</asp:ListItem>
                                        <asp:ListItem Value="Independent Electricity Retail Solutions Pty Ltd">Independent Electricity Retail Solutions Pty Ltd</asp:ListItem>
                                        <asp:ListItem Value="Integral Energy Australia">Integral Energy Australia</asp:ListItem>
                                        <asp:ListItem Value="Lumo Energy">Lumo Energy</asp:ListItem>
                                        <asp:ListItem Value="Momentum Energy">Momentum Energy</asp:ListItem>
                                        <asp:ListItem Value="Neighbourhood Energy">Neighbourhood Energy</asp:ListItem>
                                        <asp:ListItem Value="Origin Energy">Origin Energy</asp:ListItem> 
                                        <asp:ListItem Value="Powerdirect">Powerdirect</asp:ListItem>
                                        <asp:ListItem Value="Qenergy">Qenergy</asp:ListItem>
                                        <asp:ListItem Value="Red Energy">Red Energy</asp:ListItem>
                                        <asp:ListItem Value="Sanctuary Energy">Sanctuary Energy</asp:ListItem>
                                        <asp:ListItem Value="Simply Energy">Simply Energy</asp:ListItem>
                                        <asp:ListItem Value="Tarong Energy">Tarong Energy </asp:ListItem>
                                        <asp:ListItem Value="TRUenergy">TRUenergy</asp:ListItem>
                                        <asp:ListItem Value="Trustpower Australia">Trustpower Australia</asp:ListItem>
                                        <asp:ListItem Value="Victoria Electricity">Victoria Electricity</asp:ListItem>

                                        </asp:DropDownList>
                                    </EditItemTemplate>
 
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Selected Offer" 
                                    SortExpression="OFFER_SELECTION">

                                    <EditItemTemplate>

                                        <asp:DropDownList ID="SelOFFER_SELECTION" runat="server" 
                                            SelectedValue='<%# Bind("OFFER_SELECTION") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="SSE_QLD T11_8% + $75 2Y">SSE_QLD T11_8% + $75 2Y</asp:ListItem><asp:ListItem Value="SSE_QLD T11_8% PE10% + $75 2Y">SSE_QLD T11_8% PE10% + $75 2Y</asp:ListItem><asp:ListItem Value="SSE_QLD T11_8% PE25% + $75 2Y">SSE_QLD T11_8% PE25% + $75 2Y</asp:ListItem><asp:ListItem Value="SSE_QLD T11_8% PE50% + $75 2Y">SSE_QLD T11_8% PE50% + $75 2Y</asp:ListItem><asp:ListItem Value="SSE_QLD T11_8% PE100% + $75 2Y">SSE_QLD T11_8% PE100% + $75 2Y</asp:ListItem>
                                        </asp:DropDownList>

                                        <asp:RequiredFieldValidator ID="OFFER_SELECTIONVali" runat="server" 
                                            ControlToValidate="SelOFFER_SELECTION" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:BoundField DataField="PRODUCT_INCENTIVE" HeaderText="Additional Incentive for Product" 
                                    SortExpression="PRODUCT_INCENTIVE" />
                                <asp:TemplateField HeaderText="Upfront Discount for offer selected" 
                                    SortExpression="UPFRONT_DISCOUNT">

                                    <EditItemTemplate>
                                        <asp:TextBox ID="UPFRONT_DISCOUNT" runat="server" 
                                            Text='<%# Bind("UPFRONT_DISCOUNT") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Partner for Selected Offer" SortExpression="OFFER_PARTNER">

                                    <EditItemTemplate>
                                      <asp:TextBox ID="OFFER_PARTNER" runat="server" Text='<%# Bind("OFFER_PARTNER") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Company Name" SortExpression="COMPANY_NAME">

                                    <EditItemTemplate>
                                        <asp:TextBox ID="COMPANY_NAME" runat="server" Text='<%# Bind("COMPANY_NAME") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Trading Name of Company" SortExpression="TRADING_NAME">

                                    <EditItemTemplate>
                                        <asp:TextBox ID="TRADING_NAME" runat="server" 
                                            Text='<%# Bind("TRADING_NAME") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Company Position" 
                                    SortExpression="COMPANY_POSITION">

                                    <EditItemTemplate>
                                        <asp:TextBox ID="COMPANY_POSITION" runat="server" 
                                            Text='<%# Bind("COMPANY_POSITION") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="ABN" SortExpression="ABN">

                                    <EditItemTemplate>
                                        <asp:TextBox ID="ABN" runat="server" Text='<%# Bind("ABN") %>' onchange="ABNChanged()"></asp:TextBox>
                           

                                    
                                    </EditItemTemplate>

                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Annual Consumption" 
                                    SortExpression="ANNUAL_CONSUMPTION">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="ANNUAL_CONSUMPTION" runat="server" 
                                            Text='<%# Bind("ANNUAL_CONSUMPTION") %>'></asp:TextBox>
                                        <asp:RequiredFieldValidator ID="ANNUAL_CONSUMPTIONVali" runat="server" 
                                            ControlToValidate="ANNUAL_CONSUMPTION" ErrorMessage="*Required Field(Default value:1 for SME, 2 for RESD)"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>

                                </asp:TemplateField>



                                <asp:TemplateField HeaderText="Title" SortExpression="TITLE">

                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelTITLE" runat="server" 
                                            SelectedValue='<%# Bind("TITLE") %>'>
                                                <asp:ListItem Value="">Select...</asp:ListItem>
                                                <asp:ListItem>MR</asp:ListItem>
                                                <asp:ListItem>MISS</asp:ListItem>
                                                <asp:ListItem>MRS</asp:ListItem>
                                                <asp:ListItem>MS</asp:ListItem>
                                                <asp:ListItem>DR</asp:ListItem>
                                                <asp:ListItem>PROF</asp:ListItem>
                                                <asp:ListItem>REVEREND</asp:ListItem>
                                                <asp:ListItem>SIR</asp:ListItem>
                                                <asp:ListItem>FATHER</asp:ListItem>
                                               </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="TITLEVali" runat="server" 
                                            ErrorMessage="*Required Field" ControlToValidate="SelTITLE"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="First Name" SortExpression="FIRST_NAME">

                                    <EditItemTemplate>
                                        <asp:TextBox ID="FIRST_NAME" runat="server" Text='<%# Bind("FIRST_NAME") %>'></asp:TextBox>
                                        <asp:RequiredFieldValidator ID="FIRST_NAMEVali" runat="server" 
                                            ErrorMessage="*Required Field" ControlToValidate="FIRST_NAME"></asp:RequiredFieldValidator>
                                        <asp:RegularExpressionValidator ID="FIRST_NAMERE" runat="server" 
                                            ErrorMessage="Must contain more than 2 characters (Only alphabet, apostrophe, hyphen and space are allowed)" 
                                            ControlToValidate="FIRST_NAME" ValidationExpression="^[a-zA-Z'\-\s]{2,40}$"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Last Name" SortExpression="LAST_NAME">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="LAST_NAME" runat="server" Text='<%# Bind("LAST_NAME") %>'></asp:TextBox>
                                        <asp:RequiredFieldValidator ID="LAST_NAMEVali" runat="server" 
                                            ErrorMessage="*Required Field" ControlToValidate="LAST_NAME"></asp:RequiredFieldValidator>
                                        <asp:RegularExpressionValidator ID="LAST_NAMERE" runat="server" 
                                            ErrorMessage="Must contain more than 2 characters (Only alphabet, apostrophe, hyphen and space are allowed)"
                                            ControlToValidate="LAST_NAME" ValidationExpression="^[a-zA-Z'\-\s]{2,40}$"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Bill Name 1" SortExpression="BILL_NAME_1">

                                    <EditItemTemplate><asp:TextBox ID="BILLNAME1" runat="server" Text='<%# Bind("BILL_NAME_1") %>'></asp:TextBox>
                                        
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Bill Name 2" SortExpression="BILL_NAME_2">

                                    <EditItemTemplate><asp:TextBox ID="BILLNAME2" runat="server" Text='<%# Bind("BILL_NAME_2") %>'></asp:TextBox>
                                        
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Date of Birth" SortExpression="DOB">

                                    <EditItemTemplate>
                                        <asp:TextBox ID="DOB" runat="server" onclick="WdatePicker()" 
                                        Text='<%# Bind("DOB") %>' ></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="DOBVali" runat="server" 
                                            ControlToValidate="DOB" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
         


                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:BoundField DataField="DRIVERS_LICENCE" HeaderText="Drivers Licence" 
                                    SortExpression="DRIVERS_LICENCE" />
                                <asp:TemplateField HeaderText="Home Phone" SortExpression="HPHONE">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="HPHONE" runat="server" Text='<%# Bind("HPHONE") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="HPHONEVali" runat="server" 
                                            ControlToValidate="HPHONE" 
                                            ErrorMessage="Must be 10 digits including area code and no space" 
                                            ValidationExpression="\d{10}"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Business Phone" SortExpression="BPHONE">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="BPHONE" runat="server" Text='<%# Bind("BPHONE") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="BPHONEVali" runat="server" 
                                            ControlToValidate="BPHONE" 
                                            ErrorMessage="Must be 10 digits including area code and no space" 
                                            ValidationExpression="\d{10}"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Mobile Phone" SortExpression="MOBILE">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="MOBILE" runat="server" Text='<%# Bind("MOBILE") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="MOBILEVali" runat="server" 
                                            ControlToValidate="MOBILE" 
                                            ErrorMessage="Must be 10 digits including area code and no space" 
                                            ValidationExpression="\d{10}"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Email" SortExpression="EMAIL">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="EMAIL" runat="server" Text='<%# Bind("EMAIL") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Customer 2 Information Provided?" SortExpression="TITLE_CUST_2">

                                    <EditItemTemplate>

                                        <asp:DropDownList ID="SelCUST2" runat="server" onchange="SelCUST2Changed()">
                                        <asp:ListItem Value="NO" Selected="True">NO</asp:ListItem>
                                        <asp:ListItem Value="YES">YES(Please Fill All Customer2 Info Below)</asp:ListItem>
                                        </asp:DropDownList>

                                    </EditItemTemplate>

                                </asp:TemplateField>


                                <asp:TemplateField HeaderText="Customer2 Title" SortExpression="TITLE_CUST_2">

                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelTITLE_CUST_2" runat="server"
                                        SelectedValue='<%# Bind("TITLE_CUST_2") %>' >
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Mr">Mr</asp:ListItem>
                                        <asp:ListItem Value="Miss">Miss</asp:ListItem>
                                        <asp:ListItem Value="Mrs">Mrs</asp:ListItem>
                                        <asp:ListItem Value="Ms">Ms</asp:ListItem>
                                        <asp:ListItem Value="Dr">Dr</asp:ListItem>
                                        </asp:DropDownList>
                                    </EditItemTemplate>

                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Customer2 First Name" 
                                    SortExpression="FIRST_NAME_CUST_2">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="FIRST_NAME_CUST_2" runat="server" 
                                            Text='<%# Bind("FIRST_NAME_CUST_2") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="FIRST_NAME_CUST_2RE" runat="server" 
                                            ErrorMessage="Must contain more than 2 characters (Only alphabet, apostrophe, hyphen and space are allowed)" 
                                            ControlToValidate="FIRST_NAME_CUST_2" ValidationExpression="^[a-zA-Z'\-\s]{2,40}$">
                                            </asp:RegularExpressionValidator>

                                    </EditItemTemplate>

                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Customer2 Last Name" 
                                    SortExpression="LAST_NAME_CUST_2">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="LAST_NAME_CUST_2" runat="server" 
                                            Text='<%# Bind("LAST_NAME_CUST_2") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="LAST_NAME_CUST_2RE" runat="server" 
                                            ErrorMessage="Must contain more than 2 characters (Only alphabet, apostrophe, hyphen and space are allowed)" 
                                            ControlToValidate="LAST_NAME_CUST_2" ValidationExpression="^[a-zA-Z'\-\s]{2,40}$"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>
                                 </asp:TemplateField>

                                <asp:TemplateField HeaderText="Customer2 Date of Birth" SortExpression="DOB_CUST_2">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="DOB_CUST_2" runat="server" onclick="WdatePicker()" Text='<%# Bind("DOB_CUST_2") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Customer2 Drivers Licence" 
                                    SortExpression="DRIVERS_LICENCE_CUST_2">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="DRIVERS_LICENCE_CUST_2" runat="server" 
                                            Text='<%# Bind("DRIVERS_LICENCE_CUST_2") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Customer2 Home Phone" SortExpression="HPHONE_CUST_2">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="HPHONE_CUST_2" runat="server" Text='<%# Bind("HPHONE_CUST_2") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="HPHONE_CUST_2Vali" runat="server" 
                                            ControlToValidate="HPHONE_CUST_2" 
                                            ErrorMessage="Must be 10 digits including area code and no space" 
                                            ValidationExpression="\d{10}"></asp:RegularExpressionValidator>

                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Customer2 Business Phone" SortExpression="BPHONE_CUST_2">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="BPHONE_CUST_2" runat="server" Text='<%# Bind("BPHONE_CUST_2") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="BPHONE_CUST_2Vali" runat="server" 
                                            ControlToValidate="BPHONE_CUST_2" 
                                            ErrorMessage="Must be 10 digits including area code and no space" 
                                            ValidationExpression="\d{10}"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Customer2 Mobile" SortExpression="MOBILE_CUST_2">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="MOBILE_CUST_2" runat="server" Text='<%# Bind("MOBILE_CUST_2") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="MOBILE_CUST_2Vali" runat="server" 
                                            ControlToValidate="MOBILE_CUST_2" 
                                            ErrorMessage="Must be 10 digits including area code and no space" 
                                            ValidationExpression="\d{10}"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Customer2 Email" SortExpression="EMAIL_CUST_2">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="EMAIL_CUST_2" runat="server" Text='<%# Bind("EMAIL_CUST_2") %>'></asp:TextBox>
                                       <asp:RegularExpressionValidator ID="EMAIL_CUST_2RE" runat="server" 
                                            ControlToValidate="EMAIL_CUST_2"
                                            ErrorMessage="Not a valid Email(abc@gmail.com)" 
                                            ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Customer2 Relationship with Current Customer" 
                                    SortExpression="RELATIONSHIP_CODE">
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelRELATIONSHIP_CODE" runat="server" Text='<%# Bind("RELATIONSHIP_CODE") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="ZCONTP">Contact person(ZCONTP)</asp:ListItem>
                                            <asp:ListItem Value="ZRESPP">Responsible for payment(ZRESPP)</asp:ListItem>
                                        </asp:DropDownList>
                                    </EditItemTemplate>

                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Don't want to be contacted by EA?" SortExpression="DO_NOT_CONTACT">

                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelDO_NOT_CONTACT" runat="server" Text='<%# Bind("DO_NOT_CONTACT") %>'>
                                            <asp:ListItem Value=""></asp:ListItem>
                                            <asp:ListItem>Y</asp:ListItem>
                                        </asp:DropDownList>
                                    </EditItemTemplate>

                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Site Address" SortExpression="SITE_ADD1">

                                    <EditItemTemplate>
                                        <asp:TextBox ID="SITE_ADD1" runat="server" Text='<%# Bind("SITE_ADD1") %>'></asp:TextBox>
                                        <asp:RequiredFieldValidator ID="SITE_ADD1Vali" runat="server" 
                                            ControlToValidate="SITE_ADD1" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>

                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Site Suburb" SortExpression="SITE_SUBURB">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="SITE_SUBURB" runat="server" Text='<%# Bind("SITE_SUBURB") %>'></asp:TextBox>
                                        <asp:RequiredFieldValidator ID="SITE_SUBURBVali" runat="server" 
                                            ControlToValidate="SITE_SUBURB" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Site State" SortExpression="SITE_STATE">
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelSITE_STATE" runat="server"
                                        SelectedValue='<%# Bind("SITE_STATE") %>'>
                                             <asp:ListItem Value="">Select...</asp:ListItem>
                                             <asp:ListItem>VIC</asp:ListItem>
                                             <asp:ListItem>NSW</asp:ListItem>
                                             <asp:ListItem>WA</asp:ListItem>
                                             <asp:ListItem>TAS</asp:ListItem>
                                            <asp:ListItem>NT</asp:ListItem>
                                            <asp:ListItem>SA</asp:ListItem>
                                            <asp:ListItem>QLD</asp:ListItem>
                                            <asp:ListItem>ACT</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="SITE_STATEVali" runat="server" 
                                            ControlToValidate="SelSITE_STATE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Site Postcode" SortExpression="SITE_POSTCODE">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="SITE_POSTCODE" runat="server" 
                                            Text='<%# Bind("SITE_POSTCODE") %>'></asp:TextBox>
                                        <asp:RequiredFieldValidator ID="SITE_POSTCODEVali" runat="server" 
                                            ControlToValidate="SITE_POSTCODE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>


                                <asp:TemplateField HeaderText="Postal Address1 for EA Confirmation Letter" SortExpression="POST_ADDRESS_1">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="POST_ADDRESS_1" runat="server" 
                                            Text='<%# Bind("POST_ADDRESS_1") %>'></asp:TextBox>
                                        <asp:RequiredFieldValidator ID="POST_ADDRESS_1Vali" runat="server" 
                                            ControlToValidate="POST_ADDRESS_1" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:BoundField DataField="POST_ADDRESS_2" HeaderText="Postal Address2" 
                                    SortExpression="POST_ADDRESS_2" />
                                <asp:BoundField DataField="POST_ADDRESS_3" HeaderText="Postal Address3" 
                                    SortExpression="POST_ADDRESS_3" />
                                <asp:BoundField DataField="POST_ADDRESS_4" HeaderText="Postal Address4" 
                                    SortExpression="POST_ADDRESS_4" />

                                <asp:TemplateField HeaderText="Postal Suburb" SortExpression="POST_SUBURB">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="POST_SUBURB" runat="server" Text='<%# Bind("POST_SUBURB") %>'></asp:TextBox>
                                        <asp:RequiredFieldValidator ID="POST_SUBURBVali" runat="server" 
                                            ControlToValidate="POST_SUBURB" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Postal State" SortExpression="POST_STATE">
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelPOST_STATE" runat="server"
                                        SelectedValue='<%# Bind("POST_STATE") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem>VIC</asp:ListItem>
                                            <asp:ListItem>NSW</asp:ListItem>
                                            <asp:ListItem>WA</asp:ListItem>
                                            <asp:ListItem>TAS</asp:ListItem>
                                            <asp:ListItem>NT</asp:ListItem>
                                            <asp:ListItem>SA</asp:ListItem>
                                            <asp:ListItem>QLD</asp:ListItem>
                                            <asp:ListItem>ACT</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="POST_STATEVali" runat="server" 
                                            ErrorMessage="*Required Field" ControlToValidate="SelPOST_STATE"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Postal code" SortExpression="POST_POSTCODE">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="POST_POSTCODE" runat="server" 
                                            Text='<%# Bind("POST_POSTCODE") %>'></asp:TextBox>
                                        <asp:RequiredFieldValidator ID="POST_POSTCODEVali" runat="server" 
                                            ControlToValidate="POST_POSTCODE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="EA Account No." SortExpression="ACCOUNT_ID">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="ACCOUNT_ID" runat="server" Text='<%# Bind("ACCOUNT_ID") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="NMI" SortExpression="NMI">

                                    <EditItemTemplate>
                                        <asp:TextBox ID="NMI" runat="server" Text='<%# Bind("NMI") %>' onchange="NMIChanged()"></asp:TextBox>
                                    </EditItemTemplate>

                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="DPI" SortExpression="DPI">

                                    <EditItemTemplate>
                                        <asp:TextBox ID="DPI" runat="server" Text='<%# Bind("DPI") %>' onchange="DPIChanged()"></asp:TextBox>
                                    </EditItemTemplate>

                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Current Electricity Retailer" 
                                    SortExpression="CURRENT_ELECTRICITY_RETAILER">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="CURRENT_ELECTRICITY_RETAILER" runat="server" 
                                            Text='<%# Bind("CURRENT_ELECTRICITY_RETAILER") %>'></asp:TextBox>

                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="OPERATOR_NAME" SortExpression="OPERATOR_NAME">
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelOPERATOR_NAME" runat="server" 
                                        SelectedValue='<%# Bind("OPERATOR_NAME") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem>Edia Fisher</asp:ListItem>
                                            <asp:ListItem>Omar Sabbagh</asp:ListItem>
                                            <asp:ListItem>Nicolas</asp:ListItem>
                                            <asp:ListItem>Chuck Robinson</asp:ListItem>     
                                            <asp:ListItem>Kelvin Wiggins</asp:ListItem>

                                            <asp:ListItem>Others</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="OPERATOR_NAMEVali" runat="server" 
                                            ControlToValidate="SelOPERATOR_NAME" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Offer Status" SortExpression="OFFER_STATUS">
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelOFFER_STATUS" runat="server"
                                        SelectedValue='<%# Bind("OFFER_STATUS") %>'>
                                            <asp:ListItem Value=""></asp:ListItem>
                                            <asp:ListItem>Verified POS</asp:ListItem>
                                        </asp:DropDownList>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Affiliation Member Initial" 
                                    SortExpression="AFFILIATION_INITIAL">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="AFFILIATION_INITIAL" runat="server" 
                                            Text='<%# Bind("AFFILIATION_INITIAL") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Affiliation Member Surname" 
                                    SortExpression="AFFILIATION_SURNAME">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="AFFILIATION_SURNAME" runat="server" 
                                            Text='<%# Bind("AFFILIATION_SURNAME") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Affiliation Member No." 
                                    SortExpression="AFFILIATION_MEMBER_NO">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="AFFILIATION_MEMBER_NO" runat="server" 
                                            Text='<%# Bind("AFFILIATION_MEMBER_NO") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Payment Option" SortExpression="PAYMENT_OPTION">
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelPAYMENT_OPTION" runat="server"
                                        SelectedValue='<%# Bind("PAYMENT_OPTION") %>' onchange="SelPAYMENT_OPTIONChanged()">
                                            <asp:ListItem Value="">Other Method</asp:ListItem>
                                            <asp:ListItem Value="Automatic Payment">Direct debit(credit card or bank account)</asp:ListItem>
                                            <asp:ListItem>RPO</asp:ListItem>
                                        </asp:DropDownList>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="SmarterPay Credit" 
                                    SortExpression="SMARTER_PAY_CREDIT">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="SMARTER_PAY_CREDIT" runat="server" 
                                            Text='<%# Bind("SMARTER_PAY_CREDIT") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="RPO First Payment Date" 
                                    SortExpression="RPO_FIRST_PAYMENT_DATE">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="RPO_FIRST_PAYMENT_DATE" runat="server" 
                                            Text='<%# Bind("RPO_FIRST_PAYMENT_DATE") %>' onclick="WdatePicker()"></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="RPO Elec Month" SortExpression="RPO_ELEC_MONTH">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="RPO_ELEC_MONTH" runat="server" Text='<%# Bind("RPO_ELEC_MONTH") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="RPO Elec Fortn" SortExpression="RPO_ELEC_FORTN">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="RPO_ELEC_FORTN" runat="server" Text='<%# Bind("RPO_ELEC_FORTN") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="RPO Gas Month" SortExpression="RPO_GAS_MONTH">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="RPO_GAS_MONTH" runat="server" Text='<%# Bind("RPO_GAS_MONTH") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="RPO Gas_Fortn" SortExpression="RPO_GAS_FORTN">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="RPO_GAS_FORTN" runat="server" Text='<%# Bind("RPO_GAS_FORTN") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="RPO Comb Month" SortExpression="RPO_COMB_MONTH">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="RPO_COMB_MONTH" runat="server" Text='<%# Bind("RPO_COMB_MONTH") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="RPO Comb Fortn" SortExpression="RPO_COMB_FORTN">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="RPO_COMB_FORTN" runat="server" Text='<%# Bind("RPO_COMB_FORTN") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="RPO Freq Selection" 
                                    SortExpression="RPO_FREQ_SELECTION">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="RPO_FREQ_SELECTION" runat="server" 
                                            Text='<%# Bind("RPO_FREQ_SELECTION") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="DD Details Given" 
                                    SortExpression="DD_DETAILS_GIVEN">
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelDD_DETAILS_GIVEN" runat="server"
                                        SelectedValue='<%# Bind("DD_DETAILS_GIVEN") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem>Y</asp:ListItem>
                                            <asp:ListItem>N</asp:ListItem>
                                        </asp:DropDownList>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Pay Selection" SortExpression="PAY_SELECTION">
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelPAY_SELECTION" runat="server"
                                        SelectedValue='<%# Bind("PAY_SELECTION") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="D">Direct Debit</asp:ListItem>
                                            <asp:ListItem Value="R">RPO</asp:ListItem>
                                        </asp:DropDownList>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:BoundField DataField="NAME_FIN_INST" 
                                    HeaderText="Name of the Financial Institution" SortExpression="NAME_FIN_INST" />
                                <asp:BoundField DataField="ACC_HOLDER_NAME" HeaderText="Account Holder Name" 
                                    SortExpression="ACC_HOLDER_NAME" />

                                <asp:TemplateField HeaderText="BSB" SortExpression="BSB">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="BSB" runat="server" Text='<%# Bind("BSB") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="BSBVali" runat="server" 
                                            ControlToValidate="BSB" ErrorMessage="Only numbers" 
                                            ValidationExpression="\d+"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Account No." SortExpression="ACCOUNT_NUMBER">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="ACCOUNT_NUMBER" runat="server" 
                                            Text='<%# Bind("ACCOUNT_NUMBER") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="ACCOUNT_NUMBEREP" runat="server" 
                                            ControlToValidate="ACCOUNT_NUMBER" ErrorMessage="Only numbers" 
                                            ValidationExpression="\d+"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Card Type" SortExpression="CARD_TYPE">
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelCARD_TYPE" runat="server"
                                        SelectedValue='<%# Bind("CARD_TYPE") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem>VISA</asp:ListItem>
                                            <asp:ListItem>MC</asp:ListItem>
                                            <asp:ListItem>AMEX</asp:ListItem>
                                        </asp:DropDownList>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Card No." SortExpression="CARD_NUMBER">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("CARD_NUMBER") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Verify No.(3 digits)" SortExpression="VERIF_NUMBER">
                                    <EditItemTemplate>

                                        <asp:TextBox ID="VERIF_NUMBER" runat="server" 
                                            Text='<%# Bind("VERIF_NUMBER") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="VERIF_NUMBEREP" runat="server" 
                                            ControlToValidate="VERIF_NUMBER" ErrorMessage="3 digits" 
                                            ValidationExpression="\d{3}"></asp:RegularExpressionValidator>
                                                                               
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:BoundField DataField="CARD_NAME" HeaderText="Card Name" 
                                    SortExpression="CARD_NAME" />

                                <asp:TemplateField HeaderText="Expiry Date" SortExpression="EXPIRY_DATE">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="EXPIRY_DATE" runat="server" 
                                            Text='<%# Bind("EXPIRY_DATE") %>' onclick="WdatePicker()"></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="EXPIRY_DATERE" runat="server" 
                                            ControlToValidate="EXPIRY_DATE" ErrorMessage="mmyy format(4 digits)" 
                                            ValidationExpression="\d{4}"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Payment Option Prior to Sale" 
                                    SortExpression="PAYMENT_OPTION_PRIOR_TO_SALE">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="TextBox5" runat="server" 
                                            Text='<%# Bind("PAYMENT_OPTION_PRIOR_TO_SALE") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Sell Code" SortExpression="SELL_CODE">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("SELL_CODE") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Verification Operator Comments" 
                                    SortExpression="VERIFICATION_OPERATOR_COMMENTS">
                                    <EditItemTemplate>
                                    <asp:Label ID="VERIFICATION_OPERATOR_COMMENTS" runat="server" 
                                            Text='<%# Bind("VERIFICATION_OPERATOR_COMMENTS") %>'></asp:Label>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="D2D Energy offer No." 
                                    SortExpression="DOCUMENT_NUMBER">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="DOCUMENT_NUMBER" runat="server" Text='<%# Bind("DOCUMENT_NUMBER") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="D2D Agent ID(Peter Smith/ID001)" 
                                    SortExpression="D2D_REP_NAME_ID">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="D2D_REP_NAME_ID" runat="server" Text='<%# Bind("D2D_REP_NAME_ID") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="D2D Agency Name" SortExpression="D2D_AGENCY">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="D2D_AGENCY" runat="server" Text='<%# Bind("D2D_AGENCY") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Discount Percent" 
                                    SortExpression="DISCOUNT_PERCENT">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="DISCOUNT_PERCENT" runat="server" 
                                            Text='<%# Bind("DISCOUNT_PERCENT") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="DISCOUNT_PERCENTRE" runat="server" 
                                            ControlToValidate="DISCOUNT_PERCENT" ErrorMessage="only numbers" 
                                            ValidationExpression="\d{1,10}"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="MKT Green Ratio" 
                                    SortExpression="MKT_GREEN_RATIO">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="MKT_GREEN_RATIO" runat="server" 
                                            Text='<%# Bind("MKT_GREEN_RATIO") %>'></asp:TextBox>
                                        <asp:RegularExpressionValidator ID="MKT_GREEN_RATIORE" runat="server" 
                                            ControlToValidate="MKT_GREEN_RATIO" ErrorMessage="only numbers" 
                                            ValidationExpression="\d{1,10}"></asp:RegularExpressionValidator>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Delivery Point ID" SortExpression="DPID">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="TextBox13" runat="server" Text='<%# Bind("DPID") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField HeaderText="Life Support" SortExpression="LIFE_SUPPORT">
                                    <EditItemTemplate>
                                        <asp:DropDownList ID="SelLIFE_SUPPORT" runat="server" Text='<%# Bind("LIFE_SUPPORT") %>'>
                                            <asp:ListItem Value=""></asp:ListItem>
                                            <asp:ListItem>Y</asp:ListItem>
                                        </asp:DropDownList>
                                    </EditItemTemplate>
                                </asp:TemplateField>

                                <asp:TemplateField ShowHeader="False">
                                    <ItemTemplate>
                                        <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" 
                                            CommandName="Edit" Text="Edit"></asp:LinkButton>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" 
                                            CommandName="Update" Text="Update"></asp:LinkButton>
                                        &nbsp;<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" 
                                            CommandName="Cancel" Text="Cancel"></asp:LinkButton>
                                    </EditItemTemplate>
                                </asp:TemplateField>
                            </Fields>

 
                        </asp:DetailsView>

        <br />


    </div>
    </form>
</body>




<script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.4.2.min.js" type="text/javascript"></script>

<script src="date.f-0.5.0-min.js" type="text/javascript"></script>

<%--using web service with string output--%>

<script type="text/javascript">
    $(document).ready(function () {


        // DETAIL 2 PAGE LOAD START HERE


        $('#DetailsView1_UPFRONT_DISCOUNT').hide();
        $('#DetailsView1_OFFER_PARTNER').hide();


        $('#DetailsView1_AFFILIATION_INITIAL').hide();
        $('#DetailsView1_AFFILIATION_SURNAME').hide();
        $('#DetailsView1_AFFILIATION_MEMBER_NO').hide();

        $('#DetailsView1_SMARTER_PAY_CREDIT').hide();

        $('#DetailsView1_SelTITLE_CUST_2').hide();
        $('#DetailsView1_FIRST_NAME_CUST_2').hide();
        $('#DetailsView1_LAST_NAME_CUST_2').hide();
        $('#DetailsView1_DOB_CUST_2').hide();
        $('#DetailsView1_DRIVERS_LICENCE_CUST_2').hide();
        $('#DetailsView1_HPHONE_CUST_2').hide();
        $('#DetailsView1_BPHONE_CUST_2').hide();
        $('#DetailsView1_MOBILE_CUST_2').hide();
        $('#DetailsView1_EMAIL_CUST_2').hide();
        $('#DetailsView1_SelRELATIONSHIP_CODE').hide();

        //RPO seleted
        if ($('#DetailsView1_SelPAYMENT_OPTION').val() == 'RPO') {
            $('#DetailsView1_RPO_FIRST_PAYMENT_DATE').show();
            $('#DetailsView1_RPO_ELEC_MONTH').show();
            $('#DetailsView1_RPO_ELEC_FORTN').show();
            $('#DetailsView1_RPO_GAS_MONTH').show();
            $('#DetailsView1_RPO_GAS_FORTN').show();
            $('#DetailsView1_RPO_COMB_MONTH').show();
            $('#DetailsView1_RPO_COMB_FORTN').show();
            $('#DetailsView1_RPO_FREQ_SELECTION').show();
        }
        else {
            $('#DetailsView1_RPO_FIRST_PAYMENT_DATE').hide();
            $('#DetailsView1_RPO_ELEC_MONTH').hide();
            $('#DetailsView1_RPO_ELEC_FORTN').hide();
            $('#DetailsView1_RPO_GAS_MONTH').hide();
            $('#DetailsView1_RPO_GAS_FORTN').hide();
            $('#DetailsView1_RPO_COMB_MONTH').hide();
            $('#DetailsView1_RPO_COMB_FORTN').hide();
            $('#DetailsView1_RPO_FREQ_SELECTION').hide();

        }




        if ($('#DetailsView1_SelCUSTOMER_TYPE').val() == 'RESD') {

            $('#DetailsView1_BILLNAME1').hide();
            $('#DetailsView1_BILLNAME2').hide();

            $('#DetailsView1_lblCUSTOMER_TYPE').hide();
            $('#DetailsView1_SelSOHO').show();

            $('#DetailsView1_TRADING_NAME').hide();

            if ($('#DetailsView1_ANNUAL_CONSUMPTION').val() == '') {
                document.getElementById('DetailsView1_ANNUAL_CONSUMPTION').value = "2";
            }

            if ($('#DetailsView1_SelSOHO').val() == 'Not SOHO') {
                $('#DetailsView1_COMPANY_NAME').hide();
                $('#DetailsView1_COMPANY_POSITION').hide();
                $('#DetailsView1_ABN').hide();
                //$('#DetailsView1_ANNUAL_CONSUMPTION').hide();

                //var myVal = document.getElementById('DetailsView1_COMPANY_NAMEVali');
                //ValidatorEnable(myVal, false);
                //var myVal = document.getElementById('DetailsView1_COMPANY_POSITIONVali');
                //ValidatorEnable(myVal, false);
                //var myVal = document.getElementById('DetailsView1_ABNVali');
                //ValidatorEnable(myVal, false);

                //var myVal = document.getElementById('DetailsView1_ANNUAL_CONSUMPTIONVali');
                //ValidatorEnable(myVal, false);
            }
            if ($('#DetailsView1_SelSOHO').val() != 'Not SOHO') {
                $('#DetailsView1_lblCUSTOMER_TYPE').show();
                $('#DetailsView1_COMPANY_NAME').show();
                $('#DetailsView1_COMPANY_POSITION').show();
                $('#DetailsView1_ABN').show();
                //$('#DetailsView1_ANNUAL_CONSUMPTION').show();

                //var myVal = document.getElementById('DetailsView1_COMPANY_NAMEVali');
                //ValidatorEnable(myVal, true);
                //var myVal = document.getElementById('DetailsView1_COMPANY_POSITIONVali');
                //ValidatorEnable(myVal, true);
                //var myVal = document.getElementById('DetailsView1_ABNVali');
                //ValidatorEnable(myVal, true);

                //var myVal = document.getElementById('DetailsView1_ANNUAL_CONSUMPTIONVali');
                //ValidatorEnable(myVal, true);

            }






            ///var myVal = document.getElementById('DetailsView1_EMAILVali');
            ///ValidatorEnable(myVal, false);

            if ($('#DetailsView1_SelCALL_TYPE').val() == 'D2D') {
                $('#DetailsView1_SelCUST2').show();
                $('#DetailsView1_ACCOUNT_ID').hide();
                $('#DetailsView1_SelPAYMENT_OPTION').hide();
            }
            if ($('#DetailsView1_SelCALL_TYPE').val() == 'INBOUND' || $('#DetailsView1_SelCALL_TYPE').val() == 'OUTBOUND') {
                $('#DetailsView1_SelCUST2').hide();
                $('#DetailsView1_ACCOUNT_ID').show();
                $('#DetailsView1_SelPAYMENT_OPTION').show();
            }
            ///var myVal = document.getElementById('DetailsView1_CURRENT_ELECTRICITY_RETAILERVali');
            ///ValidatorEnable(myVal, false);

        }

        if ($('#DetailsView1_SelCUSTOMER_TYPE').val() == 'SME') {

            if ($('#DetailsView1_ANNUAL_CONSUMPTION').val() == '') {
                document.getElementById('DetailsView1_ANNUAL_CONSUMPTION').value = "1";
            }

            $('#DetailsView1_BILLNAME1').show();
            $('#DetailsView1_BILLNAME2').show();

            $('#DetailsView1_lblCUSTOMER_TYPE').show();
            $('#DetailsView1_SelSOHO').hide();
            $('#DetailsView1_COMPANY_NAME').show();
            $('#DetailsView1_COMPANY_POSITION').show();
            $('#DetailsView1_ABN').show();
            //$('#DetailsView1_ANNUAL_CONSUMPTION').show();
            //var myVal = document.getElementById('DetailsView1_COMPANY_NAMEVali');
            //ValidatorEnable(myVal, true);
            //var myVal = document.getElementById('DetailsView1_COMPANY_POSITIONVali');
            //ValidatorEnable(myVal, true);
            //var myVal = document.getElementById('DetailsView1_ABNVali');
            //ValidatorEnable(myVal, true);
            //var myVal = document.getElementById('DetailsView1_ANNUAL_CONSUMPTIONVali');
            //ValidatorEnable(myVal, true);


            $('#DetailsView1_TRADING_NAME').show();

            if ($('#DetailsView1_SelCALL_TYPE').val() == 'D2D') {
                //$('#DetailsView1_BILLNAME1').hide();
                //$('#DetailsView1_BILLNAME2').hide();
                $('#DetailsView1_ACCOUNT_ID').hide();
                $('#DetailsView1_SelPAYMENT_OPTION').hide();

            }
            if ($('#DetailsView1_SelCALL_TYPE').val() != 'D2D') {
                //$('#DetailsView1_BILLNAME1').show();
                //$('#DetailsView1_BILLNAME2').show();
                $('#DetailsView1_ACCOUNT_ID').show();
                $('#DetailsView1_SelPAYMENT_OPTION').show();
            }
            ///var DetailsView1_EMAILVali = document.getElementById('DetailsView1_EMAILVali');
            ///ValidatorEnable(DetailsView1_EMAILVali, true);
            $('#DetailsView1_SelCUST2').hide();
            ///var DetailsView1_CURRENT_ELECTRICITY_RETAILERVali = document.getElementById('DetailsView1_CURRENT_ELECTRICITY_RETAILERVali');
            ///ValidatorEnable(DetailsView1_CURRENT_ELECTRICITY_RETAILERVali, true);


        }



        $('#DetailsView2_UPFRONT_DISCOUNT').hide();
        $('#DetailsView2_OFFER_PARTNER').hide();


        $('#DetailsView2_AFFILIATION_INITIAL').hide();
        $('#DetailsView2_AFFILIATION_SURNAME').hide();
        $('#DetailsView2_AFFILIATION_MEMBER_NO').hide();

        $('#DetailsView2_SMARTER_PAY_CREDIT').hide();

        $('#DetailsView2_SelTITLE_CUST_2').hide();
        $('#DetailsView2_FIRST_NAME_CUST_2').hide();
        $('#DetailsView2_LAST_NAME_CUST_2').hide();
        $('#DetailsView2_DOB_CUST_2').hide();
        $('#DetailsView2_DRIVERS_LICENCE_CUST_2').hide();
        $('#DetailsView2_HPHONE_CUST_2').hide();
        $('#DetailsView2_BPHONE_CUST_2').hide();
        $('#DetailsView2_MOBILE_CUST_2').hide();
        $('#DetailsView2_EMAIL_CUST_2').hide();
        $('#DetailsView2_SelRELATIONSHIP_CODE').hide();

        //RPO seleted
        if ($('#DetailsView2_SelPAYMENT_OPTION').val() == 'RPO') {
            $('#DetailsView2_RPO_FIRST_PAYMENT_DATE').show();
            $('#DetailsView2_RPO_ELEC_MONTH').show();
            $('#DetailsView2_RPO_ELEC_FORTN').show();
            $('#DetailsView2_RPO_GAS_MONTH').show();
            $('#DetailsView2_RPO_GAS_FORTN').show();
            $('#DetailsView2_RPO_COMB_MONTH').show();
            $('#DetailsView2_RPO_COMB_FORTN').show();
            $('#DetailsView2_RPO_FREQ_SELECTION').show();
        }
        else {
            $('#DetailsView2_RPO_FIRST_PAYMENT_DATE').hide();
            $('#DetailsView2_RPO_ELEC_MONTH').hide();
            $('#DetailsView2_RPO_ELEC_FORTN').hide();
            $('#DetailsView2_RPO_GAS_MONTH').hide();
            $('#DetailsView2_RPO_GAS_FORTN').hide();
            $('#DetailsView2_RPO_COMB_MONTH').hide();
            $('#DetailsView2_RPO_COMB_FORTN').hide();
            $('#DetailsView2_RPO_FREQ_SELECTION').hide();

        }




        if ($('#DetailsView2_SelCUSTOMER_TYPE').val() == 'RESD') {

            $('#DetailsView2_BILLNAME1').hide();
            $('#DetailsView2_BILLNAME2').hide();

            $('#DetailsView2_lblCUSTOMER_TYPE').hide();
            $('#DetailsView2_SelSOHO').show();

            $('#DetailsView2_TRADING_NAME').hide();

            if ($('#DetailsView2_ANNUAL_CONSUMPTION').val() == '') {
                document.getElementById('DetailsView2_ANNUAL_CONSUMPTION').value = "2";
            }

            if ($('#DetailsView2_SelSOHO').val() == 'Not SOHO') {
                $('#DetailsView2_COMPANY_NAME').hide();
                $('#DetailsView2_COMPANY_POSITION').hide();
                $('#DetailsView2_ABN').hide();
                //$('#DetailsView2_ANNUAL_CONSUMPTION').hide();

                //var myVal = document.getElementById('DetailsView2_COMPANY_NAMEVali');
                //ValidatorEnable(myVal, false);
                //var myVal = document.getElementById('DetailsView2_COMPANY_POSITIONVali');
                //ValidatorEnable(myVal, false);
                //var myVal = document.getElementById('DetailsView2_ABNVali');
                //ValidatorEnable(myVal, false);

                //var myVal = document.getElementById('DetailsView2_ANNUAL_CONSUMPTIONVali');
                //ValidatorEnable(myVal, false);
            }
            if ($('#DetailsView2_SelSOHO').val() != 'Not SOHO') {
                $('#DetailsView2_lblCUSTOMER_TYPE').show();
                $('#DetailsView2_COMPANY_NAME').show();
                $('#DetailsView2_COMPANY_POSITION').show();
                $('#DetailsView2_ABN').show();
                //$('#DetailsView2_ANNUAL_CONSUMPTION').show();

                //var myVal = document.getElementById('DetailsView2_COMPANY_NAMEVali');
                //ValidatorEnable(myVal, true);
                //var myVal = document.getElementById('DetailsView2_COMPANY_POSITIONVali');
                //ValidatorEnable(myVal, true);
                //var myVal = document.getElementById('DetailsView2_ABNVali');
                //ValidatorEnable(myVal, true);

                //var myVal = document.getElementById('DetailsView2_ANNUAL_CONSUMPTIONVali');
                //ValidatorEnable(myVal, true);

            }






            ///var myVal = document.getElementById('DetailsView2_EMAILVali');
            ///ValidatorEnable(myVal, false);

            if ($('#DetailsView2_SelCALL_TYPE').val() == 'D2D') {
                $('#DetailsView2_SelCUST2').show();
                $('#DetailsView2_ACCOUNT_ID').hide();
                $('#DetailsView2_SelPAYMENT_OPTION').hide();
            }
            if ($('#DetailsView2_SelCALL_TYPE').val() == 'INBOUND' || $('#DetailsView2_SelCALL_TYPE').val() == 'OUTBOUND') {
                $('#DetailsView2_SelCUST2').hide();
                $('#DetailsView2_ACCOUNT_ID').show();
                $('#DetailsView2_SelPAYMENT_OPTION').show();
            }
            ///var myVal = document.getElementById('DetailsView2_CURRENT_ELECTRICITY_RETAILERVali');
            ///ValidatorEnable(myVal, false);

        }

        if ($('#DetailsView2_SelCUSTOMER_TYPE').val() == 'SME') {

            if ($('#DetailsView2_ANNUAL_CONSUMPTION').val() == '') {
                document.getElementById('DetailsView2_ANNUAL_CONSUMPTION').value = "1";
            }

            $('#DetailsView2_BILLNAME1').show();
            $('#DetailsView2_BILLNAME2').show();

            $('#DetailsView2_lblCUSTOMER_TYPE').show();
            $('#DetailsView2_SelSOHO').hide();
            $('#DetailsView2_COMPANY_NAME').show();
            $('#DetailsView2_COMPANY_POSITION').show();
            $('#DetailsView2_ABN').show();
            //$('#DetailsView2_ANNUAL_CONSUMPTION').show();
            //var myVal = document.getElementById('DetailsView2_COMPANY_NAMEVali');
            //ValidatorEnable(myVal, true);
            //var myVal = document.getElementById('DetailsView2_COMPANY_POSITIONVali');
            //ValidatorEnable(myVal, true);
            //var myVal = document.getElementById('DetailsView2_ABNVali');
            //ValidatorEnable(myVal, true);
            //var myVal = document.getElementById('DetailsView2_ANNUAL_CONSUMPTIONVali');
            //ValidatorEnable(myVal, true);


            $('#DetailsView2_TRADING_NAME').show();

            if ($('#DetailsView2_SelCALL_TYPE').val() == 'D2D') {
                //$('#DetailsView2_BILLNAME1').hide();
                //$('#DetailsView2_BILLNAME2').hide();
                $('#DetailsView2_ACCOUNT_ID').hide();
                $('#DetailsView2_SelPAYMENT_OPTION').hide();

            }
            if ($('#DetailsView2_SelCALL_TYPE').val() != 'D2D') {
                //$('#DetailsView2_BILLNAME1').show();
                //$('#DetailsView2_BILLNAME2').show();
                $('#DetailsView2_ACCOUNT_ID').show();
                $('#DetailsView2_SelPAYMENT_OPTION').show();
            }
            ///var DetailsView2_EMAILVali = document.getElementById('DetailsView2_EMAILVali');
            ///ValidatorEnable(DetailsView2_EMAILVali, true);
            $('#DetailsView2_SelCUST2').hide();
            ///var DetailsView2_CURRENT_ELECTRICITY_RETAILERVali = document.getElementById('DetailsView2_CURRENT_ELECTRICITY_RETAILERVali');
            ///ValidatorEnable(DetailsView2_CURRENT_ELECTRICITY_RETAILERVali, true);


        }

    });






    function SelCUST2Changed() {
        if ($('#DetailsView1_SelCUST2').val() == 'YES') {
            $('#DetailsView1_SelTITLE_CUST_2').show();
            $('#DetailsView1_FIRST_NAME_CUST_2').show();
            $('#DetailsView1_LAST_NAME_CUST_2').show();
            $('#DetailsView1_DOB_CUST_2').show();
            $('#DetailsView1_DRIVERS_LICENCE_CUST_2').show();
            $('#DetailsView1_HPHONE_CUST_2').show();
            $('#DetailsView1_BPHONE_CUST_2').show();
            $('#DetailsView1_MOBILE_CUST_2').show();
            $('#DetailsView1_EMAIL_CUST_2').show();
            $('#DetailsView1_SelRELATIONSHIP_CODE').show();

        }
        else {
            $('#DetailsView1_SelTITLE_CUST_2').hide();
            $('#DetailsView1_FIRST_NAME_CUST_2').hide();
            $('#DetailsView1_LAST_NAME_CUST_2').hide();
            $('#DetailsView1_DOB_CUST_2').hide();
            $('#DetailsView1_DRIVERS_LICENCE_CUST_2').hide();
            $('#DetailsView1_HPHONE_CUST_2').hide();
            $('#DetailsView1_BPHONE_CUST_2').hide();
            $('#DetailsView1_MOBILE_CUST_2').hide();
            $('#DetailsView1_EMAIL_CUST_2').hide();
            $('#DetailsView1_SelRELATIONSHIP_CODE').hide();
        }
    }


    function SelCUSTOMER_TYPEChanged() {
        if ($('#DetailsView1_SelCUSTOMER_TYPE').val() == 'RESD') {

            $('#DetailsView1_BILLNAME1').hide();
            $('#DetailsView1_BILLNAME2').hide();



            if ($('#DetailsView1_SelCALL_TYPE').val() == 'D2D') {
                $('#DetailsView1_SelCUST2').show();
                $('#DetailsView1_ACCOUNT_ID').hide();
                $('#DetailsView1_SelPAYMENT_OPTION').hide();
            }
            if ($('#DetailsView1_SelCALL_TYPE').val() != 'D2D') {
                $('#DetailsView1_SelCUST2').hide();
                $('#DetailsView1_ACCOUNT_ID').show();
                $('#DetailsView1_SelPAYMENT_OPTION').show();
            }

            $('#DetailsView1_SelSOHO').show();

            $('#DetailsView1_TRADING_NAME').hide();

            if ($('#DetailsView1_ANNUAL_CONSUMPTION').val() == '') {
                document.getElementById('DetailsView1_ANNUAL_CONSUMPTION').value = "2";
            }

            if ($('#DetailsView1_SelSOHO').val() == 'Not SOHO') {
                $('#DetailsView1_lblCUSTOMER_TYPE').hide();

                $('#DetailsView1_COMPANY_NAME').hide();
                $('#DetailsView1_COMPANY_POSITION').hide();
                $('#DetailsView1_ABN').hide();
                //$('#DetailsView1_ANNUAL_CONSUMPTION').hide();
                ///var myVal = document.getElementById('DetailsView1_COMPANY_NAMEVali');
                ///ValidatorEnable(myVal, false);
                ///var myVal = document.getElementById('DetailsView1_COMPANY_POSITIONVali');
                ///ValidatorEnable(myVal, false);
                ///var myVal = document.getElementById('DetailsView1_ABNVali');
                ///ValidatorEnable(myVal, false);
                //var myVal = document.getElementById('DetailsView1_ANNUAL_CONSUMPTIONVali');
                //ValidatorEnable(myVal, false);
            }
            if ($('#DetailsView1_SelSOHO').val() != 'Not SOHO') {
                $('#DetailsView1_lblCUSTOMER_TYPE').show();

                $('#DetailsView1_COMPANY_NAME').show();
                $('#DetailsView1_COMPANY_POSITION').show();
                $('#DetailsView1_ABN').show();
                //$('#DetailsView1_ANNUAL_CONSUMPTION').show();
                ///var myVal = document.getElementById('DetailsView1_COMPANY_NAMEVali');
                ///ValidatorEnable(myVal, true);
                ///var myVal = document.getElementById('DetailsView1_COMPANY_POSITIONVali');
                ///ValidatorEnable(myVal, true);
                ///var myVal = document.getElementById('DetailsView1_ABNVali');
                ///ValidatorEnable(myVal, true);
                //var myVal = document.getElementById('DetailsView1_ANNUAL_CONSUMPTIONVali');
                //ValidatorEnable(myVal, true);
            }



            ///var myVal = document.getElementById('DetailsView1_EMAILVali');
            ///ValidatorEnable(myVal, false);

            if ($('#DetailsView1_SelCALL_TYPE').val() == 'D2D') {
                $('#DetailsView1_SelCUST2').show();
                $('#DetailsView1_ACCOUNT_ID').hide();
                $('#DetailsView1_SelPAYMENT_OPTION').hide();
            }
            if ($('#DetailsView1_SelCALL_TYPE').val() != 'D2D') {
                $('#DetailsView1_SelCUST2').hide();
                $('#DetailsView1_ACCOUNT_ID').show();
                $('#DetailsView1_SelPAYMENT_OPTION').show();
            }
            ///var myVal = document.getElementById('DetailsView1_CURRENT_ELECTRICITY_RETAILERVali');
            ///ValidatorEnable(myVal, false);
        }

        if ($('#DetailsView1_SelCUSTOMER_TYPE').val() == 'SME') {

            $('#DetailsView1_BILLNAME1').show();
            $('#DetailsView1_BILLNAME2').show();
            $('#DetailsView1_lblCUSTOMER_TYPE').show();

            $('#DetailsView1_SelSOHO').hide();
            $('#DetailsView1_COMPANY_NAME').show();
            $('#DetailsView1_COMPANY_POSITION').show();
            $('#DetailsView1_ABN').show();

            if ($('#DetailsView1_ANNUAL_CONSUMPTION').val() == '') {
                document.getElementById('DetailsView1_ANNUAL_CONSUMPTION').value = "1";
            }


            //$('#DetailsView1_ANNUAL_CONSUMPTION').show();
            ///var myVal = document.getElementById('DetailsView1_COMPANY_NAMEVali');
            ///ValidatorEnable(myVal, true);
            ///var myVal = document.getElementById('DetailsView1_COMPANY_POSITIONVali');
            ///ValidatorEnable(myVal, true);
            ///var myVal = document.getElementById('DetailsView1_ABNVali');
            ///ValidatorEnable(myVal, true);
            //var myVal = document.getElementById('DetailsView1_ANNUAL_CONSUMPTIONVali');
            //ValidatorEnable(myVal, true);

            $('#DetailsView1_TRADING_NAME').show();

            if ($('#DetailsView1_SelCALL_TYPE').val() == 'D2D') {
                //$('#DetailsView1_BILLNAME1').hide();
                //$('#DetailsView1_BILLNAME2').hide();
                $('#DetailsView1_ACCOUNT_ID').hide();
                $('#DetailsView1_SelPAYMENT_OPTION').hide();
            }

            if ($('#DetailsView1_SelCALL_TYPE').val() != 'D2D') {
                //$('#DetailsView1_BILLNAME1').show();
                //$('#DetailsView1_BILLNAME2').show();
                $('#DetailsView1_ACCOUNT_ID').show();
                $('#DetailsView1_SelPAYMENT_OPTION').show();
            }

            ///var myVal = document.getElementById('DetailsView1_EMAILVali');
            ///ValidatorEnable(myVal, true);
            $('#DetailsView1_SelCUST2').hide();
            ///var myVal = document.getElementById('DetailsView1_CURRENT_ELECTRICITY_RETAILERVali');
            ///ValidatorEnable(myVal, true);
        }
    }


    function SelPAYMENT_OPTIONChanged() {
        if ($('#DetailsView1_SelPAYMENT_OPTION').val() == 'RPO') {
            $('#DetailsView1_RPO_FIRST_PAYMENT_DATE').show();
            $('#DetailsView1_RPO_ELEC_MONTH').show();
            $('#DetailsView1_RPO_ELEC_FORTN').show();
            $('#DetailsView1_RPO_GAS_MONTH').show();
            $('#DetailsView1_RPO_GAS_FORTN').show();
            $('#DetailsView1_RPO_COMB_MONTH').show();
            $('#DetailsView1_RPO_COMB_FORTN').show();
            $('#DetailsView1_RPO_FREQ_SELECTION').show();
        }
        else {
            $('#DetailsView1_RPO_FIRST_PAYMENT_DATE').hide();
            $('#DetailsView1_RPO_ELEC_MONTH').hide();
            $('#DetailsView1_RPO_ELEC_FORTN').hide();
            $('#DetailsView1_RPO_GAS_MONTH').hide();
            $('#DetailsView1_RPO_GAS_FORTN').hide();
            $('#DetailsView1_RPO_COMB_MONTH').hide();
            $('#DetailsView1_RPO_COMB_FORTN').hide();
            $('#DetailsView1_RPO_FREQ_SELECTION').hide();

        }

    }

    function FuelTypeChanged() {


        if ($('#DetailsView1_SelFuelType').val() == 'GAS_ONLY') {
            $("#DetailsView1_NETWORK_AREA").val('GAS NETORK AREA');
        }
        if ($('#DetailsView1_SelFuelType').val() == 'ELEC_ONLY') {
            $("#DetailsView1_NETWORK_AREA").val('ELECTRICITY NETORK AREA');
        }
        if ($('#DetailsView1_SelFuelType').val() == 'DUAL_FUEL') {
            $("#DetailsView1_NETWORK_AREA").val('ELECTRICITY NETORK AREA');
        }
    }

    function ABNChanged() {

        var checkStr = $('#DetailsView1_ABN').val();

        //var abn_fmt_str = (fmt_str) ? ‘\nThe ABN is a unique 11 digit number formed from a 9 digit unique identifier and two prefix check digits.\nThe Australian Business Register structure an ABN as XX XXX XXX XXX to assist readability.’ : ”;
        if (checkStr.length != 11 && checkStr.length != 14) {
            alert("ABN Must be 11 or 14 digits long");
        }
        else {
            var ch1 = parseInt(checkStr.charAt(0));
            var ch2 = parseInt(checkStr.charAt(1));
            var ch3 = parseInt(checkStr.charAt(2));
            var ch4 = parseInt(checkStr.charAt(3));
            var ch5 = parseInt(checkStr.charAt(4));
            var ch6 = parseInt(checkStr.charAt(5));
            var ch7 = parseInt(checkStr.charAt(6));
            var ch8 = parseInt(checkStr.charAt(7));
            var ch9 = parseInt(checkStr.charAt(8));
            var ch10 = parseInt(checkStr.charAt(9));
            var ch11 = parseInt(checkStr.charAt(10));

            var sum = 10 * (ch1 - 1) + ch2 + 3 * ch3 + 5 * ch4 + 7 * ch5 + 9 * ch6 + 11 * ch7 + 13 * ch8 + 15 * ch9 + 17 * ch10 + 19 * ch11;

            var chk = sum % 89;

            if (chk != 0) {
                alert("ABN is NOT valid!");
                $('#DetailsView1_ABN').focus();
            }

        }

    }



    function NMIChanged() {
        var checkStr = $('#DetailsView1_NMI').val();
        if (checkStr.length != 11) {
            alert("NMI Must be 11 digits long");
        }
        else {
            var hash1 = { 0: "12", 1: "13", 2: "5", 3: "6", 4: "7", 5: "8", 6: "9", 7: "10", 8: "11", 9: "12" };
            var hash2 = { 0: "15", 1: "17", 2: "1", 3: "3", 4: "5", 5: "7", 6: "9", 7: "2", 8: "4", 9: "6" };

            var ch1 = parseInt(hash1[checkStr.charAt(0)]);
            var ch2 = parseInt(hash2[checkStr.charAt(1)]);
            var ch3 = parseInt(hash1[checkStr.charAt(2)]);
            var ch4 = parseInt(hash2[checkStr.charAt(3)]);
            var ch5 = parseInt(hash1[checkStr.charAt(4)]);
            var ch6 = parseInt(hash2[checkStr.charAt(5)]);
            var ch7 = parseInt(hash1[checkStr.charAt(6)]);
            var ch8 = parseInt(hash2[checkStr.charAt(7)]);
            var ch9 = parseInt(hash1[checkStr.charAt(8)]);
            var ch10 = parseInt(hash2[checkStr.charAt(9)]);
            var ch11 = parseInt(checkStr.charAt(10));

            var sum = ch1 + ch2 + ch3 + ch4 + ch5 + ch6 + ch7 + ch8 + ch9 + ch10;
            var chk = sum % 10 + ch11;

            if (chk != 10) {
                alert("NMI is NOT valid!" + chk);
                $('#DetailsView1_NMI').focus();
            }
        }
    }


    function DPIChanged() {
        var checkStr = $('#DetailsView1_DPI').val();
        if (checkStr.length != 11) {
            alert("DPI Must be 11 digits long");
        }
        else {
            var hash1 = { 0: "12", 1: "13", 2: "5", 3: "6", 4: "7", 5: "8", 6: "9", 7: "10", 8: "11", 9: "12" };
            var hash2 = { 0: "15", 1: "17", 2: "1", 3: "3", 4: "5", 5: "7", 6: "9", 7: "2", 8: "4", 9: "6" };

            var ch1 = parseInt(hash1[checkStr.charAt(0)]);
            var ch2 = parseInt(hash2[checkStr.charAt(1)]);
            var ch3 = parseInt(hash1[checkStr.charAt(2)]);
            var ch4 = parseInt(hash2[checkStr.charAt(3)]);
            var ch5 = parseInt(hash1[checkStr.charAt(4)]);
            var ch6 = parseInt(hash2[checkStr.charAt(5)]);
            var ch7 = parseInt(hash1[checkStr.charAt(6)]);
            var ch8 = parseInt(hash2[checkStr.charAt(7)]);
            var ch9 = parseInt(hash1[checkStr.charAt(8)]);
            var ch10 = parseInt(hash2[checkStr.charAt(9)]);
            var ch11 = parseInt(checkStr.charAt(10));

            var sum = ch1 + ch2 + ch3 + ch4 + ch5 + ch6 + ch7 + ch8 + ch9 + ch10;
            var chk = sum % 10 + ch11;

            if (chk != 10) {
                alert("DPI is NOT valid!" + chk);
                $('#DetailsView1_DPI').focus();
            }
        }
    }



    function SelCUST2Changed() {
        if ($('#DetailsView2_SelCUST2').val() == 'YES') {
            $('#DetailsView2_SelTITLE_CUST_2').show();
            $('#DetailsView2_FIRST_NAME_CUST_2').show();
            $('#DetailsView2_LAST_NAME_CUST_2').show();
            $('#DetailsView2_DOB_CUST_2').show();
            $('#DetailsView2_DRIVERS_LICENCE_CUST_2').show();
            $('#DetailsView2_HPHONE_CUST_2').show();
            $('#DetailsView2_BPHONE_CUST_2').show();
            $('#DetailsView2_MOBILE_CUST_2').show();
            $('#DetailsView2_EMAIL_CUST_2').show();
            $('#DetailsView2_SelRELATIONSHIP_CODE').show();

        }
        else {
            $('#DetailsView2_SelTITLE_CUST_2').hide();
            $('#DetailsView2_FIRST_NAME_CUST_2').hide();
            $('#DetailsView2_LAST_NAME_CUST_2').hide();
            $('#DetailsView2_DOB_CUST_2').hide();
            $('#DetailsView2_DRIVERS_LICENCE_CUST_2').hide();
            $('#DetailsView2_HPHONE_CUST_2').hide();
            $('#DetailsView2_BPHONE_CUST_2').hide();
            $('#DetailsView2_MOBILE_CUST_2').hide();
            $('#DetailsView2_EMAIL_CUST_2').hide();
            $('#DetailsView2_SelRELATIONSHIP_CODE').hide();
        }
    }


    function SelCUSTOMER_TYPEChanged() {
        if ($('#DetailsView2_SelCUSTOMER_TYPE').val() == 'RESD') {

            $('#DetailsView2_BILLNAME1').hide();
            $('#DetailsView2_BILLNAME2').hide();



            if ($('#DetailsView2_SelCALL_TYPE').val() == 'D2D') {
                $('#DetailsView2_SelCUST2').show();
                $('#DetailsView2_ACCOUNT_ID').hide();
                $('#DetailsView2_SelPAYMENT_OPTION').hide();
            }
            if ($('#DetailsView2_SelCALL_TYPE').val() != 'D2D') {
                $('#DetailsView2_SelCUST2').hide();
                $('#DetailsView2_ACCOUNT_ID').show();
                $('#DetailsView2_SelPAYMENT_OPTION').show();
            }

            $('#DetailsView2_SelSOHO').show();

            $('#DetailsView2_TRADING_NAME').hide();

            if ($('#DetailsView2_ANNUAL_CONSUMPTION').val() == '') {
                document.getElementById('DetailsView2_ANNUAL_CONSUMPTION').value = "2";
            }

            if ($('#DetailsView2_SelSOHO').val() == 'Not SOHO') {
                $('#DetailsView2_lblCUSTOMER_TYPE').hide();

                $('#DetailsView2_COMPANY_NAME').hide();
                $('#DetailsView2_COMPANY_POSITION').hide();
                $('#DetailsView2_ABN').hide();
                //$('#DetailsView2_ANNUAL_CONSUMPTION').hide();
                ///var myVal = document.getElementById('DetailsView2_COMPANY_NAMEVali');
                ///ValidatorEnable(myVal, false);
                ///var myVal = document.getElementById('DetailsView2_COMPANY_POSITIONVali');
                ///ValidatorEnable(myVal, false);
                ///var myVal = document.getElementById('DetailsView2_ABNVali');
                ///ValidatorEnable(myVal, false);
                //var myVal = document.getElementById('DetailsView2_ANNUAL_CONSUMPTIONVali');
                //ValidatorEnable(myVal, false);
            }
            if ($('#DetailsView2_SelSOHO').val() != 'Not SOHO') {
                $('#DetailsView2_lblCUSTOMER_TYPE').show();

                $('#DetailsView2_COMPANY_NAME').show();
                $('#DetailsView2_COMPANY_POSITION').show();
                $('#DetailsView2_ABN').show();
                //$('#DetailsView2_ANNUAL_CONSUMPTION').show();
                ///var myVal = document.getElementById('DetailsView2_COMPANY_NAMEVali');
                ///ValidatorEnable(myVal, true);
                ///var myVal = document.getElementById('DetailsView2_COMPANY_POSITIONVali');
                ///ValidatorEnable(myVal, true);
                ///var myVal = document.getElementById('DetailsView2_ABNVali');
                ///ValidatorEnable(myVal, true);
                //var myVal = document.getElementById('DetailsView2_ANNUAL_CONSUMPTIONVali');
                //ValidatorEnable(myVal, true);
            }



            ///var myVal = document.getElementById('DetailsView2_EMAILVali');
            ///ValidatorEnable(myVal, false);

            if ($('#DetailsView2_SelCALL_TYPE').val() == 'D2D') {
                $('#DetailsView2_SelCUST2').show();
                $('#DetailsView2_ACCOUNT_ID').hide();
                $('#DetailsView2_SelPAYMENT_OPTION').hide();
            }
            if ($('#DetailsView2_SelCALL_TYPE').val() != 'D2D') {
                $('#DetailsView2_SelCUST2').hide();
                $('#DetailsView2_ACCOUNT_ID').show();
                $('#DetailsView2_SelPAYMENT_OPTION').show();
            }
            ///var myVal = document.getElementById('DetailsView2_CURRENT_ELECTRICITY_RETAILERVali');
            ///ValidatorEnable(myVal, false);
        }

        if ($('#DetailsView2_SelCUSTOMER_TYPE').val() == 'SME') {

            $('#DetailsView2_BILLNAME1').show();
            $('#DetailsView2_BILLNAME2').show();
            $('#DetailsView2_lblCUSTOMER_TYPE').show();

            $('#DetailsView2_SelSOHO').hide();
            $('#DetailsView2_COMPANY_NAME').show();
            $('#DetailsView2_COMPANY_POSITION').show();
            $('#DetailsView2_ABN').show();

            if ($('#DetailsView2_ANNUAL_CONSUMPTION').val() == '') {
                document.getElementById('DetailsView2_ANNUAL_CONSUMPTION').value = "1";
            }


            //$('#DetailsView2_ANNUAL_CONSUMPTION').show();
            ///var myVal = document.getElementById('DetailsView2_COMPANY_NAMEVali');
            ///ValidatorEnable(myVal, true);
            ///var myVal = document.getElementById('DetailsView2_COMPANY_POSITIONVali');
            ///ValidatorEnable(myVal, true);
            ///var myVal = document.getElementById('DetailsView2_ABNVali');
            ///ValidatorEnable(myVal, true);
            //var myVal = document.getElementById('DetailsView2_ANNUAL_CONSUMPTIONVali');
            //ValidatorEnable(myVal, true);

            $('#DetailsView2_TRADING_NAME').show();

            if ($('#DetailsView2_SelCALL_TYPE').val() == 'D2D') {
                //$('#DetailsView2_BILLNAME1').hide();
                //$('#DetailsView2_BILLNAME2').hide();
                $('#DetailsView2_ACCOUNT_ID').hide();
                $('#DetailsView2_SelPAYMENT_OPTION').hide();
            }

            if ($('#DetailsView2_SelCALL_TYPE').val() != 'D2D') {
                //$('#DetailsView2_BILLNAME1').show();
                //$('#DetailsView2_BILLNAME2').show();
                $('#DetailsView2_ACCOUNT_ID').show();
                $('#DetailsView2_SelPAYMENT_OPTION').show();
            }

            ///var myVal = document.getElementById('DetailsView2_EMAILVali');
            ///ValidatorEnable(myVal, true);
            $('#DetailsView2_SelCUST2').hide();
            ///var myVal = document.getElementById('DetailsView2_CURRENT_ELECTRICITY_RETAILERVali');
            ///ValidatorEnable(myVal, true);
        }
    }


    function SelPAYMENT_OPTIONChanged() {
        if ($('#DetailsView2_SelPAYMENT_OPTION').val() == 'RPO') {
            $('#DetailsView2_RPO_FIRST_PAYMENT_DATE').show();
            $('#DetailsView2_RPO_ELEC_MONTH').show();
            $('#DetailsView2_RPO_ELEC_FORTN').show();
            $('#DetailsView2_RPO_GAS_MONTH').show();
            $('#DetailsView2_RPO_GAS_FORTN').show();
            $('#DetailsView2_RPO_COMB_MONTH').show();
            $('#DetailsView2_RPO_COMB_FORTN').show();
            $('#DetailsView2_RPO_FREQ_SELECTION').show();
        }
        else {
            $('#DetailsView2_RPO_FIRST_PAYMENT_DATE').hide();
            $('#DetailsView2_RPO_ELEC_MONTH').hide();
            $('#DetailsView2_RPO_ELEC_FORTN').hide();
            $('#DetailsView2_RPO_GAS_MONTH').hide();
            $('#DetailsView2_RPO_GAS_FORTN').hide();
            $('#DetailsView2_RPO_COMB_MONTH').hide();
            $('#DetailsView2_RPO_COMB_FORTN').hide();
            $('#DetailsView2_RPO_FREQ_SELECTION').hide();

        }

    }

    function FuelTypeChanged() {


        if ($('#DetailsView2_SelFuelType').val() == 'GAS_ONLY') {
            $("#DetailsView2_NETWORK_AREA").val('GAS NETORK AREA');
        }
        if ($('#DetailsView2_SelFuelType').val() == 'ELEC_ONLY') {
            $("#DetailsView2_NETWORK_AREA").val('ELECTRICITY NETORK AREA');
        }
        if ($('#DetailsView2_SelFuelType').val() == 'DUAL_FUEL') {
            $("#DetailsView2_NETWORK_AREA").val('ELECTRICITY NETORK AREA');
        }
    }

    function ABNChanged() {

        var checkStr = $('#DetailsView2_ABN').val();

        //var abn_fmt_str = (fmt_str) ? ‘\nThe ABN is a unique 11 digit number formed from a 9 digit unique identifier and two prefix check digits.\nThe Australian Business Register structure an ABN as XX XXX XXX XXX to assist readability.’ : ”;
        if (checkStr.length != 11 && checkStr.length != 14) {
            alert("ABN Must be 11 or 14 digits long");
        }
        else {
            var ch1 = parseInt(checkStr.charAt(0));
            var ch2 = parseInt(checkStr.charAt(1));
            var ch3 = parseInt(checkStr.charAt(2));
            var ch4 = parseInt(checkStr.charAt(3));
            var ch5 = parseInt(checkStr.charAt(4));
            var ch6 = parseInt(checkStr.charAt(5));
            var ch7 = parseInt(checkStr.charAt(6));
            var ch8 = parseInt(checkStr.charAt(7));
            var ch9 = parseInt(checkStr.charAt(8));
            var ch10 = parseInt(checkStr.charAt(9));
            var ch11 = parseInt(checkStr.charAt(10));

            var sum = 10 * (ch1 - 1) + ch2 + 3 * ch3 + 5 * ch4 + 7 * ch5 + 9 * ch6 + 11 * ch7 + 13 * ch8 + 15 * ch9 + 17 * ch10 + 19 * ch11;

            var chk = sum % 89;

            if (chk != 0) {
                alert("ABN is NOT valid!");
                $('#DetailsView2_ABN').focus();
            }

        }

    }



    function NMIChanged() {
        var checkStr = $('#DetailsView2_NMI').val();
        if (checkStr.length != 11) {
            alert("NMI Must be 11 digits long");
        }
        else {
            var hash1 = { 0: "12", 1: "13", 2: "5", 3: "6", 4: "7", 5: "8", 6: "9", 7: "10", 8: "11", 9: "12" };
            var hash2 = { 0: "15", 1: "17", 2: "1", 3: "3", 4: "5", 5: "7", 6: "9", 7: "2", 8: "4", 9: "6" };

            var ch1 = parseInt(hash1[checkStr.charAt(0)]);
            var ch2 = parseInt(hash2[checkStr.charAt(1)]);
            var ch3 = parseInt(hash1[checkStr.charAt(2)]);
            var ch4 = parseInt(hash2[checkStr.charAt(3)]);
            var ch5 = parseInt(hash1[checkStr.charAt(4)]);
            var ch6 = parseInt(hash2[checkStr.charAt(5)]);
            var ch7 = parseInt(hash1[checkStr.charAt(6)]);
            var ch8 = parseInt(hash2[checkStr.charAt(7)]);
            var ch9 = parseInt(hash1[checkStr.charAt(8)]);
            var ch10 = parseInt(hash2[checkStr.charAt(9)]);
            var ch11 = parseInt(checkStr.charAt(10));

            var sum = ch1 + ch2 + ch3 + ch4 + ch5 + ch6 + ch7 + ch8 + ch9 + ch10;
            var chk = sum % 10 + ch11;

            if (chk != 10) {
                alert("NMI is NOT valid!" + chk);
                $('#DetailsView2_NMI').focus();
            }
        }
    }


    function DPIChanged() {
        var checkStr = $('#DetailsView2_DPI').val();
        if (checkStr.length != 11) {
            alert("DPI Must be 11 digits long");
        }
        else {
            var hash1 = { 0: "12", 1: "13", 2: "5", 3: "6", 4: "7", 5: "8", 6: "9", 7: "10", 8: "11", 9: "12" };
            var hash2 = { 0: "15", 1: "17", 2: "1", 3: "3", 4: "5", 5: "7", 6: "9", 7: "2", 8: "4", 9: "6" };

            var ch1 = parseInt(hash1[checkStr.charAt(0)]);
            var ch2 = parseInt(hash2[checkStr.charAt(1)]);
            var ch3 = parseInt(hash1[checkStr.charAt(2)]);
            var ch4 = parseInt(hash2[checkStr.charAt(3)]);
            var ch5 = parseInt(hash1[checkStr.charAt(4)]);
            var ch6 = parseInt(hash2[checkStr.charAt(5)]);
            var ch7 = parseInt(hash1[checkStr.charAt(6)]);
            var ch8 = parseInt(hash2[checkStr.charAt(7)]);
            var ch9 = parseInt(hash1[checkStr.charAt(8)]);
            var ch10 = parseInt(hash2[checkStr.charAt(9)]);
            var ch11 = parseInt(checkStr.charAt(10));

            var sum = ch1 + ch2 + ch3 + ch4 + ch5 + ch6 + ch7 + ch8 + ch9 + ch10;
            var chk = sum % 10 + ch11;

            if (chk != 10) {
                alert("DPI is NOT valid!" + chk);
                $('#DetailsView2_DPI').focus();
            }
        }
    }





</script>








</html>
